From: bakkiya <bakkiya@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Postgres problem with partition queries
Date: Tue, 30 Nov 2010 21:51:17 -0800 (PST)
Message-ID: <1291182677403-3287234.post@n5.nabble.com> (raw)
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.ht...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bakkiya@gmail.com
Subject: Re: Postgres problem with partition queries
In-Reply-To: <1291182677403-3287234.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox