one more performance question I cannot test yet :(

From: "Sergei Shelukhin" <realgeek(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: one more performance question I cannot test yet :(
Date: 2007-04-14 20:13:44
Message-ID: 1176581624.188553.156250@n59g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergei Shelukhin 2007-04-14 20:56:37 Re: one more performance question I cannot test yet :(
Previous Message Anton Melser 2007-04-14 20:01:46 Re: postgresql 8.1.4 to 8.2.3