Re: Sorting performance vs. MySQL

[Frank Heikens <frankheikens@xxxxxxx>]

Op 22 feb 2010, om 20:28 heeft Yang Zhang het volgende geschreven:
> > > > If your work-mem is too low there's a good chance that Postgres  
> > > > has to
> > > > use your disks for sorting, which will obviously be quite slow.
> > >
> > > Relative to the non-terminating 80-minute-so-far sort, Unix sort  
> > > runs
> > > much faster (on the order of several minutes).
> >
> > Make sure your index does fit into memory, what's the size of the  
> > index?
>
> How might I find out the size and whether it's being fit in memory?

SELECT pg_size_pretty(pg_relation_size('i_transactionid'));


> --
> Yang Zhang
> http://www.mit.edu/~y_z/
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Frank Heikens




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