Postgres problem with partition queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux