Re: Hardware upgrade for a high-traffic database - Mailing list pgsql-performance

From Tom Lane
Subject Re: Hardware upgrade for a high-traffic database
Date
Msg-id 119.1092330542@sss.pgh.pa.us
Whole thread Raw
In response to Hardware upgrade for a high-traffic database  ("Jason Coene" <jcoene@gotfrag.com>)
List pgsql-performance
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> The following suggestion works in two principles: one is that instead of
> using timestamps for ordering, integers are quicker,

The difference would be pretty marginal --- especially if you choose to
use bigints instead of ints.  (A timestamp is just a float8 or bigint
under the hood, and is no more expensive to compare than those datatypes.
Timestamps *are* expensive to convert for I/O, but comparison does not
have to do that.)  I wouldn't recommend kluging up your data schema just
for that.

            regards, tom lane

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [GENERAL] How to know which queries are to be optimised?
Next
From: "Merlin Moncure"
Date:
Subject: Re: Hardware upgrade for a high-traffic database