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 по дате отправления: