e=7084.535..7084.535 rows=18016538
loops=1)
Index Cond: ((fval >= 22) AND (fval <= 33))
Total runtime: 76015.215 ms
Still took over a minute to do the count. It seems like the index scan
happens pretty fast, but the last steps go from 7 or 8 seconds to over a
minute.
On Wed,
itmap heap scan and aggregate jump up to 6 mintues.
More detail on the table design and other stuff in a bit...
On Wed, Oct 29, 2008 at 6:18 PM, Scott Marlowe <[EMAIL PROTECTED]>wrote:
> On Wed, Oct 29, 2008 at 2:18 PM, Kevin Galligan <[EMAIL PROTECTED]>
> wrote:
> >
I'm approaching the end of my rope here. I have a large database.
250 million rows (ish). Each row has potentially about 500 pieces of
data, although most of the columns are sparsely populated.
What I'm trying to do is, essentially, search for sub-sets of that
data based on arbitrary queries of
I think I was confusing owner of database and owner of each
object. I assumed if you owned the database you could do what you
wanted with the tables in the database.
Assumptions are bad.
Thanks for the response.On 4/14/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Kevin Galligan" &
I'm a newbie. I'll admit it. I'm having some trouble.
I have 8.1 installed on ubuntu. I have a simple database set
up. I have a new user set up and I can log in as that user.
I've set the owner of the simple database to that user with 'ALTER
DATABASE [db] OWNER TO [user]', and this user shows
