http://www.postgresonline.com/journal/index.php?/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html.
Sometimes using an join instead of a subselect or indexing greatly
improves a query even before trying to optimize the default postgres
settings.
Thanks
-Mark
On Sat, Dec 8, 2012 at 5:17 PM,
Wrong list, but I would look at creating SSIS packages to transform and load
data into SQL Server. You can find out quite a bit about this from the technet
area of the Microsoft website.
Mark
On Jul 26, 2012, at 3:46, Rajat Sangal wrote:
> Hello Everyone,
>
> I want to import
Gordon
On Tue, Mar 20, 2012 at 5:02 PM, Gordon Shannon wrote:
> Hi. I'm confused about how to restrict databases from roles. When I
> create
> a new database, I thought I would have to grant connect to a role in order
> for that role to connect to it and see its objects.
>
> But...
>
> [admin@
Thanks Scott - do you ship the output to Nagios?
On Thu, Oct 20, 2011 at 4:10 PM, Scott Marlowe wrote:
> On Thu, Oct 20, 2011 at 12:16 PM, Mark Steben
> wrote:
> > Hi all,
> > I'm evaluating the check_postgres program. We are running postgres 8.3.
> > Does anybody
anything germaine to check_postgres.
Thank you,
--
*Mark Steben @ @utoRevenue*
*
* <http://www.autorevenue.com/>
> on the master postgresql.conf I set
> listen_address = '*'
> wav_level = hot_standby
> max_wal_senders = 3
>
> I didn't change any of postgresql.conf Archiving settings. They all seem
> to be commented out. Could that be the problem?
>
> Evan
>
>
> O
Do not rsync the pg_xlog. Basically that error means that the
restore_command in your recovery.conf is not working. You have hot_standby
archiving going on the master and a recovery_command on the slave, right?
On Thu, Oct 13, 2011 at 10:41 AM, Evan Walter
wrote:
>
>
> Hello,
> I am somewhat n
http://archives.postgresql.org/pgsql-hackers/2010-11/msg00252.php
Those two posts should cover the basics. There are other ways some people use
to do it, but this seems to be the generally accepted way.
I think 9.1 has some stuff in the works that should make it far easier to
monitor.
-Ma
possible cause/solution. If, for
example, you are using vmware on Linux then you might want to Google for
"vmware linux read only filesystem".
-Mark
ase of indexing postgresql's log files, you could use parameter
log_rotation_size to ensure all files are smaller than N and avoid the tsvector
limits.
-Mark
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Wednesday, June 15, 2011 12:39 PM
To
rms of
space utilization.
select length(to_tsvector('the lord of the rings.txt')) "answer";
answer
2
You might find the tsvector data consumes 2x the space required by the input
text. It will depend on your configuration and your input data. Test it and let
us kno
Did you configure a system DSN or user DSN? If connections fail for postgres
and succeed for other users, then look in the postgres user's home for hidden
file ~/.odbc.ini. Each user can have one of these hidden files.
-Mark
-Original Message-
From: 최재원 [mailto:jwc...@modernlime
ounds like there is some
bloat that I need to live with, but at least with partitioning the
amount of bloat will stay relatively constant.
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
tes, wastedsize from bloat where
wastedbytes > 0 order by wastedbytes DESC limit 20;
And this query also shows the same amount of bloat in the table itself:
select distinct(tablename), wastedbytes, wastedsize from bloat where
wastedbytes > 0 order by wastedbytes DESC limit 10;
Mark
might want to take a look at Power*Architect -
http://www.sqlpower.ca/page/architect
MD
On 05/18/2011 01:09 PM, neubyr wrote:
> Anyone knows of tools that can generate PNG/JPEG image from pgsql
> database schema?
>
> --
> neuby.r
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or
teps 1 and 2.
I have not gone past this. I ran into an issue with the one-click installer on
RHEL 6 that I'm stuck on.
-Mark
-Original Message-
From: Teguh R [mailto:tag...@gmail.com]
Sent: Friday, May 20, 2011 08:31 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] LDAP Authentica
On 05/04/2011 12:54 PM, Scott Marlowe wrote:
> On Wed, May 4, 2011 at 10:48 AM, Mark Stosberg wrote:
>>
>>>> 5. Finally, I'll drop the indexes on the parent table and
>>>> truncate it.
>>
>> Luckily I noticed the problem with TRUNCATE an
final transaction.
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Yes, understood and agreed. My mail server adds it automatically. I can
manually remove it prior to sending to the mail list.
-Mark
-Original Message-
From: Simon Riggs [mailto:si...@2ndquadrant.com]
Sent: Tuesday, May 3, 2011 10:33 AM
To: 'Mark Johnson'
Cc: 'pgsql-admin&#
write dirty pages to disk, then "echo 3 >
/proc/sys/vm/drop_caches" to remove the now clean pages, and then "cat
/proc/meminfo" one more time). And, if you are using SAN consider array based
caching as well.
Sincerely,
Mark R. Johnson
Owner, Remington Database Solutions, LL
On 04/27/2011 10:48 AM, Mark Stosberg wrote:
>
> Hello,
>
> I'm working on moving a table with over 30 million to rows to be
> partitioned. The table seeing several inserts per second. It's
> essentially an activity log that only sees insert activity and is
> l
n s
smaller chunks. I think that's the approach I'm going to consider taking.
Thanks for the input!
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
iew it instead having it rehashed here.
Thanks for the help!
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
se Edition. (According to the OLS
and Data Vault presentations I have been to, neither product alone does all of
what Trusted Oracle used to do, and Trusted Oracle didn't do all of the things
OLS and DV do today, so we would be incorrect to think its one-for-one swap).
-Mark
-Ori
ou are not opening other windows/sessions.
-Mark
that LDAP instance.
Thanks
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
with that LDAP instance.
Thanks
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
hed any light as to what I'm doing wrong? Thank you,
Mark Steben
Database Administrator
@utoRevenue | Autobase | AVV
The CRM division of Dominion Dealer Solutions
# pgpool Client Authentication Configuration File
# ===
#
# The form
erent kern.timecounter.hardware
option?
kern.timecounter.choice: TSC(800) HPET(900) ACPI-fast(1000) i8254(0)
dummy(-100)
kern.timecounter.hardware: ACPI-fast
Or does the kernel timer stuff have nothing to do with gettimeofday()?
Regards,
Mark
--
Sent via pgsql-admin mailing list (
modified using regular postgres tools, which is a a
security risk of sorts. Perhaps it might be best for you to setup certain
functions or stored procedures that their database user only has access
to? I assume this is possible, anyway.
Regards,
Mark
--
Sent via pgsql-admin mailing list
g = 'UTF8';
select * from test;
The correct results are displayed.
Is there a way, in PgAdmin, to to display the results when client_encoding
is set to WIN1252 ?
- Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
:
--- col_descr
--
-- (1 row with nothing displayed, but the length of
col_descr = 2)
6. If I execute the query:
set client_encoding = 'UTF8';
select * from test;
The correct results are displayed.
Is there a way, in PgAdmin, to to display the results when cl
> "put a C-locale index on the column", but text_pattern_ops is the way to
> do it today.
>
> regards, tom lane
>
Ok I hear you loud and clear.I am going to eat the overhead until
I get to 9.0.1, currently on 8.3.X in some places.
I will either
half as good as their
support for Oracle I think you would find it to be an amazing tool for
visualizing the database, building queries, etc.
Good luck!
Regards,
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Fri, Nov 12, 2010 at 12:45 AM, Gabriele Bartolini
wrote:
> Hi Mark,
>
> Il 12/11/10 03:31, mark ha scritto:
>>
>> I have listed what I think I will be doing with regards to initdb. if
>> anyone
>> sees problems with the following mixture during my dump -> i
TF8 -E UTF8
Thank you,
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
hings when reloading.
Just my thoughts,
~mark
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Jehan-Guillaume (ioguix)
de Rorthais
Sent: Tuesday, October 26, 2010 4:22 PM
To: Martin Povolny
Cc: pgsql-admin@postgresql.org
S
> No, it is not. The XID space is continuous and circular. For any given XID,
> there are 2^31-1 possible XIDs that are "before" it and 2^31-1 that are
> "after" it (plus the special
> FrozenXID value, which is always before everything else). There's no
> absolute comparisons possible, only
>
>> When the XID wraps, at the moment it does so, unless you set
>> vacuum_freeze_min_age to 0 and a vacuum has just been performed, is
>> there not a chance that there will be some data loss?
>
>No. XID comparisons are modulo 2^31.
>
Thanks - I'm still trying to wrap my mind around this (s
When the XID wraps, at the moment it does so, unless you set
vacuum_freeze_min_age to 0 and a vacuum has just been performed, is there not a
chance that there will be some data loss? If it changes value from (2^32 -1) to
(0), it's value is going to be less than SOME rows - the ones which have no
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Brad Nicholson
Sent: Thursday, September 23, 2010 5:53 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] long-running autovacuum tasks
On 10-09-22 06:18 PM, Mark Rostron wrote:
Version of pg
Version of pg server is 8.3.10
We have some very large tables (78 gb/ 60m rows, 132 gb/90m rows).
Storage is mounted NFS on a netapp 3160 (pretty fast I/O).
However, the tables have been autovacuuming for over 3 days (from querying
pg-stat-activity).
The current_query column value is : "autovacuum
This is occurring In an 8.4.2 pg database, and I have noticed it in 8.3.10 as
well.
We do a lot of work with temp tables here, and over time a lot of pg_temp_[n]
schemas have appeared.
Similarly, we notice build-up of pg_toast_[n] schemas.
Is it ok to drop these if they contain no tables?
Or is
Hi
We are running an 8.3.10 instance.
I need to make a change to pg_hba.conf on the fly.
Is it possible to restart just the listener for the database without cycling
the postmaster?
Mr
> That syntax is fine ... in 8.4 and up. I think you are trying to use some
> older server version, and not reading the right version of the manual.
Thanks Mr Lane
Yes - I was testing it on 8.3.10, but the manual was 8.4.2 :(
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
Ok guys - there is something here that I am not seeing Can someone please
set me straight.
I am trying to create a cursor loop with an "update where current of "
statement, but my syntax is wrong.
Would one of you be able to tell me what I'm doing.
Also: adding "for update" to the curs1 curs
Is there some way to query the data-type of ''?
like to use
The 'rolvaliduntil' column in pg_roles.
I'm wondering if there is an app inside or outside of postgres
that I can use or do I have to design from scratch.
Thanks for your time,
Mark Steben | Database Administrator
@utoRevenue® - "Keeping Customers Close"
95
I am looking for some specific information regarding optimizer behavior.
We recently experienced a situation where a query that was previously using a
btree lookup (efficient) SWITCHED to using seqscan/hash lookup.
My questions would be:
- Under what circumstances is the optimizer like
Hi
Further to David Jantzen's post of 3/16/2010.
We have decided to try to upgrade the database software from our old custom
8.3.7 instance to the std upstream 8.3.10 version.
We have no hash indexes on interval types; we therefore anticipate that the
migration will be a shutdown of the old ins
ransaction did roll back.
Good to know for future reference. Thank you.
Mark Steben | Database Administrator
<http://www.autorevenue.com> @utoRevenueR - "Keeping Customers Close"
95D Ashley Ave, West Springfield, MA 01089
413.243.4800 x1512 (Phone) |413.732-1824 (Fax)
Yep, O will go down that road if I am not duplicating any work. In my
experience building RPMS from SRPMS rarely just "works" :)
-Mark
On Feb 2, 2010, at 3:36 PM, Bruce Momjian wrote:
> Mark Corner wrote:
>>
>> So are the RPMs for postgres with non-integer dat
So are the RPMs for postgres with non-integer datetimes available? :) For
centos? :)
On Feb 2, 2010, at 2:00 PM, Bruce Momjian wrote:
> Devrim GÜNDÜZ wrote:
> -- Start of PGP signed section.
>> On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>>>
>>>
>>> No idea if anyone is building
Excuse by noobness, but where can I find the source RPMs for Centos? I
searched for a while without luck.
And which svn repository are you referring to? I assume not the postgres CVS
repo.
Thanks!
-Mark
On Feb 1, 2010, at 12:06 PM, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Mon, 2010-02
All good info...
With respect to RPMs, I was actually referring to postgres84 rpms with
non-integer datetime prebuilt.
On Feb 1, 2010, at 11:12 AM, Bruce Momjian wrote:
> Mark Corner wrote:
>> We are looking to upgrade out 8.3 db to 8.4. The full dump and
>> restore is not very
We are looking to upgrade out 8.3 db to 8.4. The full dump and
restore is not very attractive due to the downtime involved.
pg_migrator is an attractive option, but we have butted up again the
integer datetime timestamp problem:
"Old and new pg_controldata date/time storage types do not match.
inted to would be most appreciated.
Thank you,
Mark Steben│Database Administrator
@utoRevenueR-"Join the Revenue-tion"
95 Ashley Ave., West Springfield, Ma
413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion Enterprises
erence. Any
help appreciated.
Thank you,
Mark Steben│Database Administrator
@utoRevenueR-"Join the Revenue-tion"
95 Ashley Ave., West Springfield, Ma
413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion Enterprises
We are currently using Slony for our client's database that has million of
rows on some tables and 12GB of raw data.
So far so good, we set it up as a service and using a watchdog script to
monitor and notify us in case the service fails.
On Fri, Nov 27, 2009 at 12:19 AM, Dimitri Fontaine
wrote:
; > What can I do?
> > Can anybody help me?
> >
> > Thanks.
> >
> > Regards MisterX
> >
>
>
>
> --
> Brian Modra Land line: +27 23 5411 462
> Mobile: +27 79 69 77 082
> 5 Jan Louw Str, Prince Albert, 6930
> Postal: P.O. Box 2, Prince Alb
fter start command - perhaps I need to sleep for 5
seconds before the test).
Thanks for your time,
Mark Steben│Database Administrator
@utoRevenueR-"Join the Revenue-tion"
95 Ashley Ave., West Springfield, Ma
413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax)
@utoRevenue is a registered tradema
closed and when we push this out, everything will once again
Be right with the world.
Thanks to all for the help.
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion"
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
@uto
that it hung because it was
A transaction? Even so I thought those lock types were compatible.
As always thanks for your time.
Mark Steben│Database Administrator│
@utoRevenueR "Join the Revenue-tion"
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732
own plugin to check that no more than 10 of the last
100 searches took more than 10 seconds to execute. If that is ever true, we
definitely have a situation we want to look into.
What luck have others of you had with devising a way to monitor if your
PostgreSQL server is "slow" ?
Great to see the announcement of the 8.4 rollout. Quick question - is hot
standby available or still being worked on?
I see mention of it in the pgsql admin archives but I don't see it in the
documentation.
Thanks,
Mark Steben│Database Administrator│
@utoRevenueR "Join the Revenu
I'm up to the challenge. I'll be adding a wiki page and slowly adding to it.
Thanks for the suggestion.
-- Sent from my Palm Pre512 689-7705Emanuel Calvo Franco wrote:
2009/6/25 Mark Lehmann :
> I have been looking for a best practices layout for Postgres.
>
> The Centos
created a best practice for placing pg_xlogs, regular logs,
data, indexes, binary code, and configuration files onto the filesystem?
I would rather use a widely accepted standard than invent one based on one
competitors of Postgres.
--
Mark Lehmann
512 689-7705 M
ing exists exactly matching that for which I am looking.
Anything close or even not so close would be helpful. I'm willing to create
one for PostgreSQL for review by the community if it would be helpful.
--
Mark Lehmann
512 689-7705 M
a new character encoding that will be case
insensitive?
Thanks,
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
00010C2800B1 came into xlog as 16777216, just like the
others.
Thanks for the response.
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion"
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
@utoRevenue is a
28/B1FFEC5C
Feb 25 10:08:12 ar-db3 postgres[32538]: [9-1] @: LOG: invalid secondary
checkpoint record
Feb 25 10:08:12 ar-db3 postgres[32538]: [10-1] @: PANIC: could not locate a
valid checkpoint record
Feb 25 10:08:12 ar-db3 postgres[32537]: [1-1] @: LOG: startup process (PID
32538) was termin
ly availability
And then to place back in 'recovery mode' for the next nights set of
Logs But it doesn't lend itself to this type of application.
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion"
95 Ashley Ave. West Springfield, MA., 01089
413-24
ut 2GB of logs every hour. Is there a config
parameter to reduce the amount that Xlog takes up? At this rate I'm looking
at close to 400GB to restore the database at the end of the week.
Any help appreciated.
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion&q
81 log?
Thanks,
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion"
COME SEE US AT NADA BOOTH #1021, HALL B, IN NEW ORLEANS!
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
@utoRevenue is a registered tradema
Thanks for the clarifications Kevin, Josh, Simon
I am trying out Kevin's suggestion to create a second standby copy now.
I know I have to create the base copy and send it over, at least
For the first time to start recovery. I will look at rsync to do that.
Thanks for all the help -- Mark
then we will. I just want to make sure I'm
understanding your advice.
Thanks
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion"
COME SEE US AT NADA BOOTH #1021, HALL B, IN NEW ORLEANS!
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone)
a log got partially copied and postgres
cannot find a valid checkpoint to restart. What is the best way to remedy
this situation? Pg_resetxlog perhaps?
Thanks for your help
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion"
COME SEE US AT NADA BOOTH #1021, HALL B
ng @utoEnthusiasts. Please provide us with your feedback.
_
Mark Steben│Database Administrator│ <http://www.autorevenue.com/>
@utoRevenueT
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
A Division of Dominion Enterprises
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2008 10:06 PM
To: Mark Steben
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] question on warm standby
"Mark Steben" <[EMAIL PROTECTED]> writes:
> I am running postg
ast this, then I can play around with pg_standby and get
Real warm_standby started.
Thanks for your help,
Committed to Creating @utoEnthusiasts. Please provide us with your feedback.
____
Mark Steben│Database Administrator│ @utoRevenueT
95 Ashley Ave. West Springfield,
specific PIDs. Not something I want to do manually at 1 am every
morning.
We are at postgres 8.2.5. Thanks for your help
<mailto:[EMAIL PROTECTED]> Committed to
Creating @utoEnthusiasts. Please provide us with your feedback.
_____
Mark Steben│Database Administrator│
meantime, any ideas on how
To fix this?
Thank you,
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
msteben mailto:[EMAIL PROTECTED]> @autorevenue.
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
[EMAIL PROTECTED]
Visit our new website at
www.autorevenue.com
IMPORTANT: The information contained in this
t the checkpoint
request failed.
Is there any way replay the restore to get out of this pickle, or do I start
from scratch?
Fortunately this is a development server so I have the luxury of recopying
production.
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterp
Thanks Alvaro - did as you suggested and looks to be working better
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
[EMAIL PROTECTED]
Visit our new website at
s vacuumed manually
during the day do have this
LAST_VACUUM column updated. The autovacuum does populate the
LAST_AUTOVACUUM column
For these tables.
Any insights? Thanks
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee
Any help would be appreciated. Thank you,
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
msteben mailto:[EMAIL PROTECTED]> @autorevenue.com
Visit ou
The doc says to do an initdb and reload the data whenever you run
pg_resetxlog. Do you concur with that even if we are only resetting the OID
counter?
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, February 08, 2008 11:36 AM
To: Mark Steben
Cc: pgsql-admin
]
Sent: Friday, February 08, 2008 11:19 AM
To: Mark Steben
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Error on CLUSTER command
"Mark Steben" <[EMAIL PROTECTED]> writes:
> I am getting the following error when I attempt to CLUSTER on a table:
> mavmail=# cluster mailer_
eduled for implementation later this
month or early March.
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
msteben mailto:[EMAIL PROTECTED]> @autorevenue.c
Hi folks, getting this error in production:
unexpected chunk number 0 (expected 1) for toast value 34761
Any ideas on how to approach this?
Two of the tables in the query have toast tables, one does not.
Thanks,
Mark Steben
Senior Database Administrator
@utoRevenueT
A
Thanks Tom - that did the trick
We will be upgrading to 8.2 within the next couple weeks.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 22, 2008 12:20 PM
To: Mark Steben
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] no entry on pg_database for a
this?
Any ideas would be appreciated
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
msteben mailto:[EMAIL PROTECTED]> @autorevenue.com
Vis
All feedback would be appreciated.
Thank you,
Mark Steben
_
From: Mark Steben [mailto:[EMAIL PROTECTED]
Sent: Friday, December 28, 2007 10:09 AM
To: 'pgsql-admin@postgresql.org'
Cc: '[EMAIL PROTECTED]'; 'David Parks'; 'Craig Brothers'
Sub
massive growth
over the
Next 2 - 3 years.
Any thoughts / comments would be appreciated.
Also are there tools out there that monitor disk I/O and disk speed?
Thanks for your time,
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480
Does anybody have suggestions as to what Entity_Relationship diagram tool
Is out there that'll work for Postgres?
Thank you,
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
n to be 8.2.5 per Scott M.)
Thanks,
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
msteben mailto:[EMAIL PROTECTED]> @autorevenue.com
Vis
ffers. I
know this is
Very large for 7.4.5 but may be more appropriate for 8.2.4. Any thoughts?
Thank you,
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporat
Thanks Tom, every piece of new information adds to my education.
I'm going to put to bed this effort of trying to verify BGWRITER,
knowing that it works in 8.2 and move on.
Regards,
Mark Steben
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, October 22, 2
emain in
memory until syncpoint in pre-8.0. Am I missing somethng?
Thanks for your time
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
msteben mailto:[
1 - 100 of 205 matches
Mail list logo
