Hi,
The setup in question includes PostGRESQL v8.2.4, Java based web servers and
MS.NET based web servers. Following is the fuzzy situation:
1. Our SQL queries run very fast using PSQL (both, from the server as
well as the client).
2. The Java app also retrieves the results very fast
Hello.
I have a postgresql 8.2.4 server that ran low on disk space. I was
seeing messages
about some queries failing to run, and a hint about low disk space.
I noticed that the largest table in the database was returning 0 rows,
while other tables
just seemed to be missing some rows. One
On Tue, Apr 08, 2008 at 04:52:23PM -0300, Sergio Gabriel Rodriguez wrote:
> needs of others which can't be found because the script will generate
> them later. How can I make an orderer sql dump???
Use the custom format, use pg_restore to get the catalogue, and then edit
that catalogue to re-order
Hi,
How do i get DDL of a Table from system catalog ?
Purpose :
1) i need to create an external table on the basis of another table.
create table ext_table (like table_name); --> this doesnot work for external tables.
2) so i need to query catalog to get definition of the
Hello all
my struggle with the database continues (see earlier thread titled "too many
trigger records found for relation xyz").
Today, I created yet another to table to the same database. Everything went
ok, no errors or anything, but when I checked pg_tables -view I saw two
tables with the same
On Tue, Apr 08, 2008 at 12:13:36PM +0200, Johann Spies wrote:
> I have got 8x720G disks in a hardware raid 5 setup. It is a Dell 2950
Thow away your RAID 5. It's a loser for this. Raid 1+0 is what you need.
> server. I am using an XFS-filesystem. I am not certain about the
On another note, I'
try starting psql with -E (would show queries psql does) option and \d+ the
table
To: [EMAIL PROTECTED]: Wed, 9 Apr 2008 08:50:44 -0500Subject: [ADMIN] How do i
get DDL of a Table from system catalog ?From: [EMAIL PROTECTED],How do i get
DDL of a Table from system catalog ?Purpose :1) i need to create an external
table on the basis of another table. create table ext
