Skip site navigation (1) Skip section navigation (2)

Re: Could not open relation with OID (table partitioning issue?)

From: bakkiya <bakkiya(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Could not open relation with OID (table partitioning issue?)
Date: 2010-11-24 04:41:25
Message-ID: 1290573685411-3277881.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice
This is different from the actual error, just wanted to post about this also.
When queries are running on partition table, EXPLAIN statements are going to
waiting state.
For ex:
I am running 
SELECT
	events.dp AS target_port,
	count(events.dp) as hits
FROM
	events
WHERE
	events.rid02 = 23243
	AND events.sip = 455545
	AND events.dp IS NOT NULL
	AND (events.evt_time >= '2010-09-01 16:00:00')
	AND events.evt_time <= '2010-09-01 16:05:00')
GROUP BY
	events.dp
ORDER BY
	2 DESC
LIMIT 10

And in a different session I am running 
EXPLAIN <same sql statement mentioned above>
THis EXPLAIN statement is in waiting state. Is this expected behaviour?

-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/Could-not-open-relation-with-OID-table-partitioning-issue-tp3265708p3277881.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

pgsql-novice by date

Next:From: Sheena O'ConnellDate: 2010-11-24 16:17:52
Subject: Running Postgresql on Windows sans install
Previous:From: Michael RowanDate: 2010-11-24 00:13:29
Subject: Multi-row insert using a Function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group