[GENERAL] My DB has has 5TB, many operations are very slow (on Google Cloud Compute)

Hi, My DB has has 5TB, it's on Google Cloud Compute, mostly on SSDs, part on Standard Persistent Disks. Querying is ok, but deleting, moving between tablespaces, dropping tables, etc, etc is hugely slow (note: I do have a number of indexes) Instance RAM: 60GB Instance CPU: 16Cores I'm just wond

FW: [GENERAL] PL/pgSQL Function Help

w) Thanks Tom! -- David -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 3:30 PM To: Niblett, David A Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PL/pgSQL Function Help "Niblett, David A" <[EMAIL PROTECTED]&g

[GENERAL] PL/pgSQL Function Help

I've got an issue with a plpgsql function and I have not been able to find any reference to this situation in searching. I hope that someone can point me in the correct direction. I'm running v8.0.3 and assuming a test set up of: - CREATE TYPE myrec AS ( id int );

[GENERAL] IDENT Authentication

failed for user "superbiskit" OK, so how do I convince the postmaster that I am myself? Or, how do I disarm this form of authentication in favor of plain old password? Thanks, -- David A. Cobb, Software Engineer, Public Access Advocate "By God's Grace, I am a Christian man

[GENERAL] Follow-up to original post, more information:

put --- Where to go from here? ---- David A. Ulevitch - Founder, EveryDNS.Net Washington University in St. Louis http://david.ulevitch.com -- http://everydns.net ---(end of broadcast)---

[GENERAL] trying to restore after a server failure...need some help

ort of there but not really. The login account works and it thinks spark_db exists but I can't query the tables or anything... Sadly, there are no other backups of this data other than what I recovered from the old server. What can we do from here? Are there any expert