one more performance question I cannot test yet :( - Mailing list pgsql-general

From Sergei Shelukhin
Subject one more performance question I cannot test yet :(
Date
Msg-id 1176581624.188553.156250@n59g2000hsh.googlegroups.com
Whole thread Raw
List pgsql-general
Suppose there's a table with two text fields and a lot of int fields.
THe table will be huge, updated constantly, and will be searched by
all of the int fields, whereas text fields will be for display only.

Does it make sense to split it vertically into two tables, one with
ints and one with texts, and join them in queries to make it faster?


pgsql-general by date:

Previous
From: "Lloyd Mason"
Date:
Subject: Re: Unexplained case insensitive results
Next
From: "richyen3@gmail.com"
Date:
Subject: autovacuum vacuums entire database...is this right?