Re: Question on partitioning

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Question on partitioning
Дата
Msg-id CANzqJaBN=V+DjQt9veDGd9miE4bcE-7s3tY7DWsn1y4dh2ufyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question on partitioning  (veem v <veema0000@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Feb 6, 2024 at 2:40 PM veem v <veema0000@gmail.com> wrote:
Thank you Laurenz. Got it.

So basically , you mean to say any DDL on a table won't allow the table to be read by other processes. I was under the assumption that it should allow the read queries to move ahead at least. I must be wrong here. Thanks for correcting me.

That word "any" in "any DDL" is quite a big word.  It's certainly not going to allow reads while you're adding a Foreign Key.

And the whole purpose of adding the CONCURRENTLY key word to CREATE INDEX is because regular CREATE INDEX statements block everyone else.

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

Предыдущее
От: veem v
Дата:
Сообщение: Re: Question on partitioning
Следующее
От: Sean v
Дата:
Сообщение: Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY