Re: [ADMIN] top posting?

s an average of about 8 a day replying to a guy trolling on about a 20-year-old argument . Can we put it to bed now please? Geoff

Re: [ADMIN] diskspace

On 6 February 2013 11:12, Geoff Winkless wrote: > On 6 February 2013 11:04, Albe Laurenz wrote: > >> Have you tried using pg_filedump >> (http://pgfoundry.org/frs/?group_id=1000541) >> to dump a page or two of your table and figure >> out what is where and where th

Re: [ADMIN] diskspace

gt; out what is where and where the space went? > I haven't; I will do for interest's sake, thanks for the suggestion. Geoff

Re: [ADMIN] diskspace

On 5 February 2013 20:33, Geoff Winkless wrote: > http://www.postgresql.org/docs/9.2/static/storage-page-layout.html gives > detail... > > Let's say around 249MB (23 bytes per row, according to that page) for the > columns you mention, so that leaves 234MB unexplained. > &

Re: [ADMIN] diskspace

HeaderData). Given page size of 8kb that would imply page headers of about 3.3MB over a 611MB table. Even with some bytes for alignment I'm Still not seeing where 230MB (more than the space taken by the data itself) of my disk is gone. Thanks! Geoff

[ADMIN] diskspace

. I expected a little overhead from what I'd read before the migration but that's a fairly huge difference. As I said, sorry if I've missed the obvious "use loads of extra space" setting but I'd appreciate any suggestion as to what that setting might be called :) Cheers Geoff

[ADMIN] Alter column varchar(n) via updating pg_attribute

? (Naturally I'm also in the process of testing). Thanks, Geoff --- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] configuration kerberos in Postgre sql

that matter, /etc/hostname and /etc/resolv.conf would be good to see too because of their importance here. HTH, Geoff - Geoff Tolley DBA/Systems Administrator YouGovPolimetrix 285 Hamilton Avenue Suite 200 Palo Alto, CA 94301 geoff.tol...@yougov.com http://www.yougov.com/ -- Sent via

Re: [ADMIN] How overcome wait for vacuum full?

from mytable_old. I'm afraid you'll have to sort out manually what these should be. */ 7.3.8 is quite seriously old. 7.3.19 is the latest in that tree if you must stick with it. HTH, Geoff ---(end of broadcast)--- TIP 1: if posting/

Re: [ADMIN] How overcome wait for vacuum full?

ought to be able to reclaim disk space by the copy/drop original/rename procedure, but that gets hard to manage if you have triggers or foreign keys on the table in question. You might want to use CREATE TABLE table_copy (LIKE orig_table) to preserve column defaults if you go down tha

Re: [ADMIN] Multiple auth types for a connection

implications of SSL vs non-SSL connectivity, wouldn't it be possible to have something like: hostnosslall all 0.0.0.0/0 krb5 hostssl all all 0.0.0.0/0 md5 ... and then have sslmode set to prefer or allow on the client

Re: [ADMIN] disk usage spike

Unfortunately I didn't notice the problem until I saw the logs today, and by then it was back tor normal.  Is it safe to assume this is abnormal behaviour? Geoff. - Original Message From: Tom Lane <[EMAIL PROTECTED]>To: Geoff Parker <[EMAIL PROTECTED]>Cc: pgsql ad

[ADMIN] disk usage spike

lier (4am) that morning.    Is it possible the spike was caused by autovacuum re-indexing the pg_largeobject table? Thanks, Geoff.

[ADMIN] Disk usage in postgresql 8.1.4

l This is Postresql version 8.1.4 on a slightly modified version of RHEL 4 (2.6.17 kernel). Thanks, Geoff.

Re: [ADMIN] Installation Error - binary - PostgreSQL 8.1.2

Thanks for the help, PostgreSQL and/or the installer crashes at startup, fails to start or hangs on start but the remedy identified in the FAQ does not help, any other suggestions? > PostgreSQL 8.1.2 binary > O/S Windows XP Pro > > Trying to install via the msi but fails get following error in

[ADMIN] Installation Error - binary - PostgreSQL 8.1.2

. Can anyone help? Geoff. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives

[ADMIN] Testing for a record before update or insert without using a function.

Is it possible to test if a record exists in a table and then if it does do an update on that table or if it doesn't do an insert ? I've looked around the documents and it seems everything points towards a function? Is this the only way or has someone done this before.....

[ADMIN] Date Problem on Imports to 7.2.1

y! Is there a flag or setting within the database that will allow us to import the date correctly? thanks in anticipation.. Geoff Ellis ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] Date Problem on Imports to 7.2.1 [ SOLVED ]

lt but this default can be changed at compile time or at run time. thanks. Geoff -Original Message- From: Geoff Ellis [mailto:[EMAIL PROTECTED] Sent: 27 August 2003 13:38 To: 'Pgsql-Admin (E-mail)' Subject: Date Problem on Imports to 7.2.1 We have some date problems when impor

[ADMIN] Function problem.

help me here, I've looked through the 7.3rc1 Docs shipped with pgadmin and can't quite see what I'm after... thanks Geoff ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Function Problem

Thanks guys, I've cracked it now... yeah, a lot of syntax errors, but to be honest, I never got to look at the pl syntax page. Thanks to Jakub for the link, it helped solve the problem... thanks again.. Geoff -Original Message- From: Robert Treat [mailto:[EMAIL PROTECTED]] Sen

[ADMIN] Function Problem

the end of the function... RETURN NULL; END Can anyone see what I've done wrong in there? TIA Geoff Here is my trigger and function. trigger == CREATE TRIGGER doc_status_trig AFTER UPDATE ON document_status FOR EACH ROW EXECUTE PROCEDURE mon_sum_update() function == CREATE

[ADMIN] Triggers/Rules?

really really appreciate some pointers on how to achieve my goal and relieve me of this thorn in my side! thanks very much geoff ellis ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[ADMIN] Database Diagrams.

ching with the wrong phrase's etc ). I'm using a Win32 client to develop, but the DB runs on a debian linux server. TIA Geoff --- This message is intended only for the person or entity to which it is addressed

FW: [ADMIN] FW: Linking databases.

ted a user it would cascade and delete the users_access records. are you saying this is impossible? if so, are their plans for this to be made a feature in a future release? many thanks Geoff -Original Message- From: omid omoomi [mailto:[EMAIL PROTECTED]] Sent: 11 July 2002 10:55 To: [

[ADMIN] FW: Linking databases.

eb.column", but just can't find the right syntax... I'm using 7.2 thanks geoff --- This message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged m