From: | bakkiya <bakkiya(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Postgres problem with partition queries |
Date: | 2010-12-01 05:51:17 |
Message-ID: | 1291182677403-3287234.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
We are having a partition table and we are querying some rows in the
partition.
select * from events where
events.evt_time >= '2010-11-29 00:00:00'
AND events.evt_time <= '2010-11-30 23:59:59'
While this query is in running state, I am issuing a drop statement on a
partition of this table.
drop table events_p_20101207130000
Please note that the query is running on a different partition and drop is
happening on a different partition.
Now, in a different session, I am running a different query,
select * from events where
events.evt_time >= '2010-11-28 00:00:00'
AND events.evt_time <= '2010-11-29 23:59:59'
Now the issue is both the drop and my 2nd query is in waiting state and both
these queries started running after my first queries completion.
We have set constraint_exclusion to on and we used, select * from
pg_stat_activity where waiting = 'true' query to check the status of the
waiting queries.
Now, can you please explain me on why it is behaving like this. Is this a
postgres bug or any configuration needs to be done to avoid this waiting.
Any help is really appreciated.
Thanks,
Bakki
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-problem-with-partition-queries-tp3287234p3287234.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-12-01 14:35:06 | Re: Postgres problem with partition queries |
Previous Message | Samuel Stearns | 2010-11-30 23:34:24 | Re: Setting Schema on Restore |