Hi List;
Anyone have any thoughts per which logging method (SYSLOG vs STDERR) is the
better approach ?
Thanks in advance...
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
On Sunday 08 July 2007 16:21:42 Ben Kim wrote:
> On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson wrote:
> >I have been asked if it is possible to asynchronously replicate a
> > postgresql database to ms-sql. My answer is yes, provided postgresql
> > ORM features aren't used in the de
Hi List;
I want to determine which table is being vacuumed.
I ran this:
postgres=# select procpid, current_query from pg_stat_activity where
current_query = 'VACUUM';
procpid | current_query
-+---
9902 | VACUUM
(1 row)
Then I ran this:
postgres=# select relation fr
On Wednesday 22 August 2007 22:10:05 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > Then I ran this:
> >
> > postgres=# select relation from pg_locks where pid = 9902;
> > relation
> > ---
> > 82097999
> > 143
On Monday 27 August 2007 21:44:29 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > How do I check to see which tables have been vacuumed recently and when
> > they were last vacuumed?
>
> As of 8.2, there are columns about this in the pg_stat views, as
Hi List;
How do I check to see which tables have been vacuumed recently and when they
were last vacuumed?
Thanks in advance...
/Kevin
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.
Hi List;
can I run queries to see the following for postgres v 8.1.4:
a) where the db is per used transaction ID's (want to avoid a transaction ID
wrap-around scenario)
b) a list of tables in the db and the last time they were vacuumed
Thanks in advance
/Kevin
---(e
Hi List;
Is there a method/syntax I can use to rename a constraint ?
Thx
/Kevin
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Thursday 30 August 2007 07:12:48 Alvaro Herrera wrote:
> Kevin Kempter wrote:
> > Hi List;
> >
> > can I run queries to see the following for postgres v 8.1.4:
>
> Update to 8.1.9 *soon* unless you want to be victim of a nasty autovac
> bug. And in case you alre
On Tuesday 04 September 2007 10:59:38 Tena Sakai wrote:
> Hi Everybody,
>
> I had been running postgres with postgresql.conf file
> as little changed as possible from distributed version.
> And lately I became a bit curious as well as confused.
>
> In my configuration file both lines
> #listen_ad
On Tuesday 04 September 2007 12:06:29 Tena Sakai wrote:
> Thank you, Kevin Kempter.
> Thank you, Kevin Grittner,
>
> In order for me to accept foreign odbc connection,
> one of the things I must to is to change
> listen_addresses = 'localhost'
> to something l
On Wednesday 12 September 2007 11:10:51 Jessica Richard wrote:
> Everything was running fine under the default number 5432. After the port
> number was changed to another number in postresql.conf file and the server
> was restarted, dblink is broken, it is still looking for the old port
> number 5
Hi List;
Can I query the system catalogs in 8.1.4 and determine the last time a
database or table was accessed?
Thanks in advance
/Kevin
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Wednesday 03 October 2007 01:01:00 Khan, Mahmood Ahram wrote:
> Hi,
>
>
>
>
>
>
> 1.What are necessary steps we should follow for migration of a
> production database from Oracle 10g (10.2.0.1) to PostgreSQL 8.2.4?
> 2.What are the most common issues we get and how to fix them in
> migra
Hi List;
we have some monitoring/alert scripts which run sql against the database
(8.1.4) as a non-superuser. The problem is I get
when trying to access current_query from pg_stat_activity.
I ran these grant statements but still no joy:
grant select on pg_stat_activity to monitor_user;
grant
On Thursday 11 October 2007 12:33:24 Jessica Richard wrote:
> I created a test user with the following command:
>
> $ createuser test
> Shall the new role be a superuser? (y/n) n
> Shall the new role be allowed to create databases? (y/n) n
> Shall the new role be allowed to create more new roles? (
On Wednesday 17 October 2007 03:05:22 Alexis Beuraud wrote:
> Hello all
>
> Is there a way to execute a SQL script whenever the Postgres server starts
> up?
> I would like to run the SQL command "analyze" at startup time. (I might use
> more complicated scripts in the future).
>
> I have not found
Hi All;
In addition to bumping up the max_fsm_pages value, I'm preparing to run a full
db vacuum to avoid a transaction ID wrap-around failure for an 8.1.4 server.
(we do have autovacuum on, and we're using the 8.2 defaults). I'm doing this
based on a recent message from a regular vacuum verb
Hi List;
I'm wanting to better understand wal / checkpoint segments.
I have a cluster which has checkpoint_segments set to 32 and wal_buffers set
to 24.
I see consistently 66 files in pg_xlog and I've recently implemented wal
archiving and so far there are 41 segments/files in the wal archive
On Thursday 01 November 2007 22:38:02 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > What's the relationship between wal_buffers and checkpoint_segments?
>
> None particularly.
>
> > even
> > though the max distance between checkpoints is
On Thursday 01 November 2007 23:38:48 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > Also I suspect after each filesystem backup I should remove the older
> > archived segments since the file system backup makes them
> > irrelevant. Is this accurate?
On Thursday 01 November 2007 23:52:00 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > One more question. I see a fair amount of file changed warnings in the
> > tar output. Like this:
> >
> > tar: ./data/base/82097725/4242350944: file change
Hi List;
I'm working with a client with several highly active 8.1.4 servers. I want to
run a weekly cron that will vacuum ALL db tables except those with entries in
pg_autovacuum (where we've setup manual/cron vacuums) in order to eliminate
transaction ID wraparound failure warnings (which come
from the list, then run the vacuum on the remaining tables
once a week to avoid transaction ID wraparound failures.
/Kevin
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > I'm working with a client with several highly active 8.1.4 servers. I
> > want to run a week
Hi List;
I've got an index name in pg_class and I want to figure out which table it
belongs to, any suggestions?
Thanks in advance
/Kevin
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choo
Hi list;
We're seeing this error whern trying to restore a pg_dump file:
-
pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0x9f CONTEXT:
COPY log_customer_api, line 4551 pg_res
Anyone know where I can find a full list of the strftime patterns that can be
used for log_filename ?
Thanks in advance..
/Kevin
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Thursday 10 January 2008 00:38:38 nalini wrote:
> Dear All
>
> I have a application running at various locations with backend as postgres
> Slony is configured at all locations for replication at local site anda
> central server where each site has its own database instance.
>
> Now we wish to m
On Thursday 10 January 2008 12:27:37 David Wall wrote:
> I'm trying to get WAL file copying working across two systems. It seems
> pretty straightforward to handle this in the "archive_command" of the
> primary, in which I am able to copy the files easily to a staging area
> for the backup system.
Hi List;
I'm engaging with a client who is trying to solve what sounds like a bloat
issue. However in further conversations they told me this:
1) we have a table that is an integer key and a blob column
2) the table was at 30Gig, we went in and deleted the last 2 months of data
and it's still a
Hi List;
Suppose I have a table with say an integer key, a char column and a large
object column.
can I simply delete a row from the table (delete from bigtable where...), then
run a vacuum (or vacuum full) ? If so, in this scenario will postgres release
the space back to the OS or must I firs
Hi List;
Trying to restore a pg_dump I get this:
pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0xae
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY imm_lookup, lin
Hi List;
What's the source equivelant of postgresql-python. Is it a client interface ?
Is it the same as "./configure --with-python" ?
Thanks in advance.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http:
Hi List;
Is there a system catalog, or other means where I can find out the last time a
table was analyzed and the last time a table was vacuumed?
Thanks in advance,
/Kevin
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Hi List;
Anyone have any insight for the error below ?
(we got it in a phgAdmin session)
I checked the logs and didn't see anything, however the logging levels are at
the defaults. Were running version 8.2.4
"An I/O error occured while sending to the backend."
Thanks in advance
/Kevi
Hi List;
I've placed this sql in a script:
psql my_db
Hi LIst;
I have 2 Linux servers:
192.168.111.11
192.168.111.13
Both are running postgres v 8.2.6
I can ping the .11 box from .13 and vice versa
I can connect remotely from the .11 box to the .13 box but I cannot
connect to the .11 box from the .13 box.
I can do this:
on the 192.168.111.11
ewall/iptables/SE issues?
Thanks in advance
On Mar 28, 2008, at 10:45 AM, Jonathan Nalley wrote:
are you running any kind of firewall/iptables/SELinux where the
settings are perhaps not the same on the two machines?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
] On Behalf Of
92.168.111.11 but it might eliminate some layer of issues. If
you're familiar with nmap or similar programs you can accomplish the
same thing to ping .11 on port 5432
-Original Message-
From: kevin kempter [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2008 12:56
To: Jonatha
wherereject-
with icmp-ho
st-prohibited
[EMAIL PROTECTED] ~]#
On Mar 28, 2008, at 11:45 AM, Shane Ambler wrote:
kevin kempter wrote:
Can you point me where to look for firewall/iptables/SE issues?
Start with the output of iptables -L on both machines (you may need
to run th
Hi List;
I'm setting up a warm standby server on version 8.1.9
I setup a recovery.sh script to keep the standby cluster in recovery
mode waiting for the next WAL segment. everything works fine as long
as the standby server is in recovery mode. I see the recovery taking
place in the postg
Hi All;
we seem to be getting deadlock quite a lot. We have a python process
that does the following and we keep getting deadlocks. Is this a real
deadlock or maybe a wait condition? Any help in debugging / resolving
this would be much appreciated.
Thanks in advance
cursor.execute("
On May 13, 2008, at 5:00 PM, Tom Lane wrote:
Tino Schwarze <[EMAIL PROTECTED]> writes:
On Tue, May 13, 2008 at 01:18:24PM -0600, kevin kempter wrote:
ProgrammingError: deadlock detected
DETAIL: Process 23098 waits for ShareUpdateExclusiveLock on
relation 428126 of database 427376; bloc
Hi List;
Can I install a PL/pgSQL function so it's global to all databases
within a cluster or do I need to install per database ?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgs
Hi All:
I have this table:
# \d seg_id_tmp7
Table "public.seg_id_tmp7"
Column |Type | Modifiers
-+-+---
customer_srcid | bigint |
show_srcid | bigint
I forgot to mention - I'm running version 8.3.1
On May 20, 2008, at 12:14 PM, kevin kempter wrote:
Hi All:
I have this table:
# \d seg_id_tmp7
Table "public.seg_id_tmp7"
Column |Type
wow, good catch.
Thanks for taking the time to look.
On May 20, 2008, at 1:22 PM, Shane Ambler wrote:
kevin kempter wrote:
Hi All:
I want to insert some data along with a -1 for two of the bigint
columns. like this:
insert into seg_id_tmp7
( customer_srcid,
show_srcid
Hi list;
I'm trying to get postgres & syslog to get along with no luck. I'm
running freeBSD7 and postgres 8.3.1
Here's my postgres setup
log_destination = 'syslog'
#logging_collector = off
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
silent_mode = on
log_min_duration_statement = 0
Hi List;
How could I select the current UTC time ? now() cast as a timestamp
at UTC is wrong because it takes now() and says: if it were now() time
UTC what would it be here (timezone) and returns that. I want to
return 'what time is it now in UTC ?'
Thanks in advance...
/Kevin
--
Sen
On Jun 5, 2008, at 1:01 PM, kevin kempter wrote:
Hi List;
How could I select the current UTC time ? now() cast as a timestamp
at UTC is wrong because it takes now() and says: if it were now()
time UTC what would it be here (timezone) and returns that. I want
to return 'what time
Hi List;
I've found that if I run this select (below) I get a table returned
named 'dma' een though I specified like 'dm_%' :
select tablename from pg_tables where tablename like 'dm_%';
tablename
--
dm_service_provider_dim
dma
Am I missing somethi
OK. Thanks for the info.
On Jun 30, 2008, at 5:48 PM, Stephan Szabo wrote:
I've found that if I run this select (below) I get a table returned
named 'dma' een though I specified like 'dm_%' :
Underscore is a special character for like matching any single
character
so I don't think that'
Hi List;
in trying to drop an index I get this:
# drop index sl_pf_fact_tmp11_ep_idx11;
ERROR: could not open relation with OID 3666815
I even dropped the associated table and still get this error. Likewise
we cannot create an index with the same name.
Thoughts ?
--
Sent via pgsql-admi
Hi All;
Sorry f this is a duplicate post, my first post from yesterday never
showed up.
we have a table that has a PK as follows:
CREATE TABLE btx (
id integer NOT NULL,
url character varying(256) NOT NULL,
"password" character varying(50),
btx_counter integer,
...
size do
appened, I think the rule needs to be that we only execute a failover
based on bringing the master down as opposed to simply creating the
trigger file. I'm trying to test this theory out now - I'll update
the list with my findings.
/Kevin
On Jul 8, 2008, at 10:52 AM, Alvaro He
Hi All;
I want to dump a set of BLOB's from one db/server and import to another.
I assume I cannot do a pg_dump unless I also dump related
pg_largeobject rows for the referenced OID
I assume I'll need to export via distinct lo_export commands and use
lo_import to insert into the second dat
Hi All;
Can I put an update/insert/delete trigger on a BLOB (lo_* style)
column, It looks like the trigger should actually live on the data
column of the pg_largeobject table to be effective. Is this correct ?
Thanks in advance...
--
Sent via pgsql-admin mailing list (pgsql-admin@postgres
Hi All;
I'm unclear per the docs what the effect is of specifying a shared
buffers value without a kB or an MB at the end.
For example if I specify shared buffers as:
shared_buffers = 5000
would this equate to 5000 8K pages, or 5000K, 5000bytes?
I usually specify the buffers in MB but I w
Thanks !
On Sep 15, 2008, at 7:10 PM, Tom Lane wrote:
kevin kempter <[EMAIL PROTECTED]> writes:
I'm unclear per the docs what the effect is of specifying a shared
buffers value without a kB or an MB at the end.
For example if I specify shared buffers as:
shared_buffers = 5000
Hi All;
Is there an easy way to determine the actual OS disk cache size or at
least a set of guidelines based on the OS and disk subsystem type ?
Thanks in advance...
/Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.
Hi All;
I've gone into contribs/pg_buffercache and run this:
make (as postgres)
make install (as root)
psql -f pg_buffercache.sql
when I run the psql command against my database I get this:
BEGIN
SET
psql:pg_buffercache.sql:9: ERROR: could not access file "$libdir/
pg_buffercache": No such
ok so I have more info.
a pg_config --libdir shows me /usr/lib64
however the make install installs the pg_buffercache in /pgmoveable/
lib/postgresql
Thoughts ?
On Sep 19, 2008, at 3:51 PM, kevin kempter wrote:
Hi All;
I've gone into contribs/pg_buffercache and run this:
mak
On Sep 19, 2008, at 4:18 PM, Jeff Frost wrote:
kevin kempter wrote:
ok so I have more info.
a pg_config --libdir shows me /usr/lib64
however the make install installs the pg_buffercache in /pgmoveable/
lib/postgresql
How was postgresql installed on the machine in the first place
Hi List;
I want to pull the list of column names from the system catalogs for a
specified table. I only want column names, I want to exclude any index
names, or other non-column name rows. I got this far (see below)
however this query produces additional rows with attname's like
tableoid
Hi all;
I'm trying to run a restore from a pg_dump and I get loads of these:
invalid command \N
I see lots of \N char's in the data for some of the tables (NULL's ?)
Thoughts?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscri
On Oct 17, 2008, at 3:20 PM, Jan-Peter Seifert wrote:
Hello,
kevin kempter wrote:
I'm trying to run a restore from a pg_dump and I get loads of these:
invalid command \N
I see lots of \N char's in the data for some of the tables (NULL's ?)
Are you using pgAdmin&#
Hi All;
I wonder is there a way to force autovacuum events to be logged to the
postgres log ?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi All;
I'm working on a vacuum monitor script to alert us when tables start to grow
out of control per dead space. Initially I excluded the system catalog
schemas (pg_catalog, pg_toast, etc) however I wonder if maybe I should monitor
these as well. PLus I'm looking for any input as to specific
On Wednesday 24 December 2008 09:56:29 Scott Marlowe wrote:
> On Wed, Dec 24, 2008 at 9:31 AM, Kevin Kempter
>
> wrote:
> > Hi All;
> >
> > I'm working on a vacuum monitor script to alert us when tables start to
> > grow out of control per dead space. Initi
Hi all;
Anyone know what system catalogs I need to query to find out # of disk reads
and # of memory / buffercache reads ?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi all;
Anyone know where to look to see when tables were last vacuumed via autovacuum
?
Also, can I run this check only in 8.3+ or did it work also in 8.2, 8.1 ?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://
Hi All;
Can someone point me in the direction of more info per the usagecount value in
the pg_buffercache view, or send me a description beyond "Page LRU count"
There's no README in my postgresql-8.3.5/contrib/pg_buffercache dir and I've
found nothing more in the online manual.
Thanks in adva
Hi All;
Is it possible to add triggers to system catalog and/or statistics collector
tables ?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Tuesday 10 March 2009 11:13:54 Carol Walter wrote:
> I want to recreate users with their passwords from one database
> cluster on another database cluster. What would be the best way for
> me to do this?
>
> Thanks,
> Carol
from the "old" server run this (where is the new server):
pg_dumpal
Hi All;
I'm looking for thoughts/feedback on the use of UNIX Sockets vs standard CIDR
style access (i,e, Ident, MD5, etc) to a Postgres Cluster. What are the
pros/cons, which is more secure and why, etc...
Thanks in advance
So, if price were not an option and you had a system that needed to average
10K+ inserts per second what HW would you recommend? (Obviously there's mega
architectural issues here)
Server?
(Dell PowerEdge 905? , HP Proliant DL700?)
Direct Attached Storage:
(Dell MD3000? HP MSA70?)
RAID/Storage
Hi all;
I cannot connect to a postgres (8.3) cluster locally (via ssh onto the
server).
The postgresql.conf file has this:
# - Connection Settings -
listen_addresses = '*'
#listen_addresses = '0.0.0.0' # what IP address(es) to listen on;
# comma-separated list of addr
Hi all;
I'm seeing a number of vacuum's in one of our db's that has a notation (to
prevent wraparound).
I've tried a number of things to fix it. last nite during the off hours we ran
a
"vacuumdb -a"
The vacuumdb did vacuum every db in the cluster but I'm still seeing the
vacuums to prevent w
On Thursday 25 June 2009 08:25:53 Tom Lane wrote:
> Kevin Kempter writes:
> > I'm seeing a number of vacuum's in one of our db's that has a notation
> > (to prevent wraparound).
>
> This is a normal condition. There isn't anything you can do that will
&
On Thursday 25 June 2009 10:08:16 Greg Stark wrote:
> On Thu, Jun 25, 2009 at 4:39 PM, Kevin
>
> Kempter wrote:
> > we're inserting an average of 70-100 rows per second into these tables.
>
> Hm. And every row is a separate transaction? That's still only a few
>
Hi all;
is it possible to see how much work_mem memory a particular session is using?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi All;
I have an sql stmt that runs:
insert into x
( a.col1, a.col2, a.col3,b.col1,b.col2)
select blah,blah,blah
...
from giant_table a,
even_bigger_table b
where.
I wonder, could I convert this to use COPY into the table (x) instead of the
select stmt?
Thanks in advance
--
Se
On Tuesday 21 July 2009 10:35:46 Carol Walter wrote:
> Hello,
>
> I emailed to the group last week about being able to access one of my
> postgres databases from other machines on my network. I thought the
> problem was a installation of 8.2.10 that I had been testing an
> upgrade on had clobbered
Hi all;
looking at a system running 8.1.15
via a select from pg_stat_activity I see a row where the vcurrent_query =
'VACUUM'
I see also that autovacuum is on. Would autovacuum be running a vacuum on the
entire db? I didn't think autovacuum did that. If not, how do I know in
version 8.1 what t
Can I use a check constraint, or something other than a function to force a
column to be lowercase only?
Thx in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi all;
due to operator error at one of my client sites we're trying to restore a
deleted db.
We did a restore with a pgdump that went fine but the dump is 3weeks old. they
do have WAL segments and they claim that the WAL segments are exactly in line
with the needed transactions - from a timin
On Tuesday 11 August 2009 09:49:14 Tom Lane wrote:
> Kevin Kempter writes:
> > due to operator error at one of my client sites we're trying to restore a
> > deleted db.
> >
> > We did a restore with a pgdump that went fine but the dump is 3weeks old.
> > th
Hi all;
we want to insert a single backslash into a bytea column (running postgres v
8.3.5)
this works to insert 2 backslashes (but we only want one):
insert into test_bytea_tab (id, bytea_test_col)
values(99, 'testdata'::bytea)
However none of these work:
insert into test_bytea_tab (
Hi all;
we have a large table that gets a lot of churn throughout the day.
performance has dropped off a cliff. A vacuum verbose on the table showed us
this:
INFO: "action_rollup_notifier": found 0 removable, 34391214 nonremovable row
versions in 152175 pages
DETAIL: 22424476 dead row vers
On Tuesday 18 August 2009 13:37:12 Tom Lane wrote:
> Kevin Kempter writes:
> > INFO: "action_rollup_notifier": found 0 removable, 34391214 nonremovable
> > row versions in 152175 pages
> > DETAIL: 22424476 dead row versions cannot be removed yet.
> >
> >
I'm running a vacuum full on a table due to excessive updates/deletes. It's
been running for more than an hour (it's about 3Gig in size)
2 questions:
1) is there any way to gain some visibility per the progress of the vacuum
full
2) can I safely kill the vacuum full and do a dump, drop table,
Hi all;
we've been fighting this query for a few days now. we bumped up the statistict
target for the a.id , c.url_hits_id and the b.id columns below to 250 and ran
an analyze on the relevant tables. we killed it after 8hrs.
Any suggestions?
$ psql -ef expl.sql pwreport
Hi all;
I'm moving a db install from one server to another. the source box had 2
tablespaces and I see this in the pg_tblspc dir:
lrwxrwxrwx 1 postgres postgres 20 2009-08-10 19:23 17261 ->
/san_B/pwreport_3000
lrwxrwxrwx 1 postgres postgres 20 2009-08-11 17:20 17625 ->
/san_A/pwreport_1000
lr
On Sunday 06 September 2009 00:05:04 Brian Modra wrote:
> Hi,
> I'm maintaining a fairly large online database, and am trying to free
> up disk space. Its got to 98% full.
> I am certain that the postgresql data files are responsible for more
> than 97% of this partition's usage.
> The WAL logs for
ally large
> pg_toast_4643492 index...
>
> (I'm using this to find out which are the largest relations:
> SELECT relname, reltuples, relpages FROM pg_class ORDER BY relpages DESC;)
>
> How do I force a reindex hitting just that pg_toast_ relation?
>
> 2009/9/6 Kevin Kemp
If I want to set the statistics target for a column in a partitioned table to
a higher value, say 250, do I need to alter each partition? or can I just
alter the base table (and the partitions will inherit the change)?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgr
Hi All;
we're getting these errors on our system today:
Sep 9 00:53:45 ux-rqs04-atl2 ri_load[5846]: Caught Exception!
Shutting down: ERROR: could not read block 703769 of relation
37698/17627/38565: Input/output error CONTEXT: SQL statement "SELECT
1 FROM ONLY "our_schema"."big_table" x WH
On Wednesday 09 September 2009 12:22:29 Tom Lane wrote:
> Kevin Kempter writes:
> > we're getting these errors on our system today:
> >
> > Sep 9 00:53:45 ux-rqs04-atl2 ri_load[5846]: Caught Exception!
> > Shutting down: ERROR: could not read block 703769 o
Hi all;
How / where can I find which tablespace the indexes live in?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi all;
I have an sql query I like to run that shows the top 10 bloated tables. I'm
wanting to turn it into a munin graph however the issue is that the list of
tables (the top 10) are not constant which seems to indicate that I need
something more dynamic than what's available as a standard mu
1 - 100 of 122 matches
Mail list logo
