-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Is it established practice in the Postgres world to separate indexes
from tables? I would assume that the reasoning of Richard Foote -
albeit for Oracle databases - is also true for Postgres:
Yes, it's an established practice. I'd call it
Hi all:
Can someone please guide me as to how to solve this problem? If this is the
wrong forum, please let me know which one to post this one in. I am new to
Postgres (about 3 months into it)
I have PostGres 9.0 database in a AWS server (x-large) and a pgplsql program
that does some
On Wed, Apr 25, 2012 at 7:08 PM, Greg Sabino Mullane g...@turnstep.com wrote:
Is it established practice in the Postgres world to separate indexes
from tables? I would assume that the reasoning of Richard Foote -
albeit for Oracle databases - is also true for Postgres:
Yes, it's an
On Wed, Apr 25, 2012 at 11:52 AM, Venki Ramachandran
venki_ramachand...@yahoo.com wrote:
Hi all:
Can someone please guide me as to how to solve this problem? If this is
the wrong forum, please let me know which one to post this one in. I am new
to Postgres (about 3 months into it)
I have
Venki Ramachandran venki_ramachand...@yahoo.com wrote:
I have PostGres 9.0 database in a AWS server (x-large) and a
pgplsql program that does some computation. It takes in a date
range and for one pair of personnel (two employees in a company)
it calculates some values over the time period.
Hello
2012/4/25 Venki Ramachandran venki_ramachand...@yahoo.com:
Hi all:
Can someone please guide me as to how to solve this problem? If this is the
wrong forum, please let me know which one to post this one in. I am new to
Postgres (about 3 months into it)
I have PostGres 9.0 database in a
Another question (probably a silly mistake) while debugging this problem:
I put in insert statements into the pgplsql code to collect the
current_timestamp and see where the code was spending most of it timeThe
output is as follows:
Hello
http://www.postgresql.org/docs/8.1/static/functions-datetime.html
CURRENT_TIME and CURRENT_TIMESTAMP deliver values with time zone;
LOCALTIME and LOCALTIMESTAMP deliver values without time zone.
CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME, and LOCALTIMESTAMP can
optionally take a precision
On 04/25/2012 02:46 AM, John Lister wrote:
Hi, I'd be grateful if you could share any XFS performance tweaks as I'm
not entirely sure I'm getting the most out of my setup and any
additional guidance would be very helpful.
Ok, I'll give this with a huge caveat: these settings came from lots of
Replacing current_timestamp() with transaction_timestamp()
and statement_timestamp() did not help!!!.
My timestamp values are still the same. I can't believe this is not possible in
PG. In oracle you can use 'select sysdate from dual' and insert that value and
you can see which sql statement
Venki Ramachandran venki_ramachand...@yahoo.com writes:
Replacing current_timestamp() with transaction_timestamp()
and statement_timestamp() did not help!!!.
You did not read the documentation you were pointed to. Use
clock_timestamp().
regards, tom lane
--
Sent
On Wed, Apr 25, 2012 at 1:52 PM, Venki Ramachandran
venki_ramachand...@yahoo.com wrote:
Hi all:
Can someone please guide me as to how to solve this problem? If this is the
wrong forum, please let me know which one to post this one in. I am new to
Postgres (about 3 months into it)
I have
On Wed, Apr 25, 2012 at 12:52 PM, Venki Ramachandran
venki_ramachand...@yahoo.com wrote:
Hi all:
Can someone please guide me as to how to solve this problem? If this is
the wrong forum, please let me know which one to post this one in. I am new
to Postgres (about 3 months into it)
I have
13 matches
Mail list logo