Robert Treat wrote:
On Monday 12 November 2007 18:31, Andrew Dunstan wrote:
1. when someone replies to your post at the bottom, please don't put
your reply at the top. It makes everything totally unreadable.
+1
2. you should investigate one or more of: pg_memcache, solid state disk.
you might also consider creating a tablespace on tmpfs or ramfs or something
like pramfs
FYI, Postgres is know to be used successfully on some *extremely* heavy
websites, without using tables pinned in memory.
+1
I give this a +/- 1. Yes extremely heavy websites can do this *but* they
require extremely expensive hardware to do so.
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
