Re: Related To Hash Partition

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Related To Hash Partition
Дата
Msg-id CAMkU=1yQM9L_P1mFwhdjxV6KuCSbGtqk1VUetzU7+fQa433FpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Related To Hash Partition  (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
Ответы Re: Related To Hash Partition  (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
Список pgsql-admin
On Sun, Apr 23, 2023 at 3:04 AM ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> wrote:

Hi Team,

While using hash partition i am facing the problem that the data is not going into the proper partition table .
Due to this, records are not visible in the main table when I am searching for a particular record, as it searches only that partition.
Any suggestions on how to overcome this problem and why this happened.

This seems like a bug, or some kind of corruption.  But there isn't enough info here to identify what the bug might be.  Are you using a custom hashing function, or a built-in one?  What is the datatype of the partition key?  Has this system been through any pg_upgrade cycles?  Have you tried to reproduce it on your own system?  What is your version and hardware and OS?  Do you have error correcting code RAM?

And in the future, if i truncate the records from the main table and insert them back again, will the shuffling of records happen or not.
Any ideas regarding why this happened? 

I don't think there is a way to answer that without first identifying what went wrong in the first place.
 

 Just add up the indexing.


I don't know what that means. 

Cheers,

Jeff

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bethany Davis
Дата:
Сообщение: Can't use accounts with .local emails
Следующее
От: richard coleman
Дата:
Сообщение: Re: how to list privileges on the database object itself via SQL?