Jonathan Vanasco wrote:
can anyone offer some suggestions on tweaking a system for
write-intensive operations?
but the updating of the records as having been audited ( a bool flag )
takes 5-10 minutes per set.
What's the limiting factor? Disk? CPU?
Any chance of seeing the queries that are
can anyone offer some suggestions on tweaking a system for write-
intensive operations?
my new box is running great for reads / selects , and with 60
connections on tests.
however i'm in the middle of a schema migration / audit, and its
taking ungodly slow.
selecting + analyzing 10,000 r
On 27 Mar 2007 05:10p -0400, Justin Dearing wrote:
> Hello, I currently store html color codes in that database with the
> following DOMAIN:
>
> CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$');
>
> Has anyone created a custom type that has additional functionality (eg
> fo
Geoffrey wrote:
Joseph S wrote:
Fedora/Redhat has debuginfo packages that drop files with debug
symbols in /usr/src/debug/, and gdb can use them. Does anyone know
how this works and how I can get those files from the pg tarball?
Where have you found these packages? Is this an rpm you have l
Hi,
On Tue, 2007-03-27 at 22:04 -0400, Tom Lane wrote:
> Red Hat makes their debuginfo RPMs available in the normal course
> of things (they're usually in a debug/ subdirectory of wherever you
> find the RPMs)
Fedora and Red Hat 5 users can download debuginfo packages via yum.
Fedora users need
Geoffrey <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> You download and install the postgresql-debuginfo RPM that exactly
>> matches your other postgresql RPM(s).
> I just downloaded 8.2.3 for RHWS 5 but did not see a debuginfo rpm.
> Also looked for them same for 7.4.16 but didn't find a debu
Tom Lane wrote:
Joseph S writes:
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
You download and install the postgresql-debuginfo RPM that ex
Joseph S writes:
> Tom Lane wrote:
>> You download and install the postgresql-debuginfo RPM that exactly
>> matches your other postgresql RPM(s).
> I don't use rpms, I build from the tarballs, hence my question.
You'd have to dig into the RPM code enough to figure out how it
separates the debug
On Mar 27, 2007, at 3:58 PM, Jorge Godoy wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
On 3/27/07, Erik Jones <[EMAIL PROTECTED]> wrote:
Not having looked myself, this is as much a question as a
suggestion, but
are there not postgres dba training seminars/courses you could
recommend
Tom Lane wrote:
Joseph S writes:
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
You download and install the postgresql-debuginfo RPM that ex
Joseph S writes:
> Fedora/Redhat has debuginfo packages that drop files with debug symbols
> in /usr/src/debug/, and gdb can use them. Does anyone know how this
> works and how I can get those files from the pg tarball?
You download and install the postgresql-debuginfo RPM that exactly
matches
[EMAIL PROTECTED] (Tony Caduto) writes:
> Another thing is this, how hard could it possibly be for a MS SQL DBA
> or Oracle DBA to pick up using PostgreSQL?
> I don't think it would take a decent admin of any database to come up
> to speed in a very short time as long as they were interested in doi
Hello, I currently store html color codes in that database with the
following DOMAIN:
CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$');
Has anyone created a custom type that has additional functionality (eg
format the input or output to other formats, retrieve red, green o
On Tue, 2007-03-27 at 15:58, Jorge Godoy wrote:
> I have the same opinion. Just look around and see how many "certified
> something" are there and how many of them *really* know the product, its
> details, how to work with it.
>
> Certifications don't even certify the minimum knowledge. They ar
Joseph S wrote:
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
Where have you found these packages? Is this an rpm you have located?
--
Until
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On 3/27/07, Erik Jones <[EMAIL PROTECTED]> wrote:
>> Not having looked myself, this is as much a question as a suggestion, but
>> are there not postgres dba training seminars/courses you could recommend
>> they send their dba's to?
>
> There are some
On Tue, Mar 27, 2007 at 03:57:49PM -0400, Joseph S wrote:
> Does anyone know how this works and how I can get those files
> from the pg tarball?
My guess: strip -o
Peter
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
On Tue, 2007-03-27 at 15:09, Tony Caduto wrote:
> >> The sad reality from what I have observed is that unless more people gain
> >> those skills and want to work in ops, it's becoming very hard for me to
> >> justify recommending postgresql for enterprise (or larger) scale projects.
> >>
> >> Wha
On Fri, 2007-02-23 at 12:07 -0800, Ron Mayer wrote:
> Jim Nasby wrote:
> > The problem with using simple OS priority settings is you leave yourself
> > wide open to priority inversion.
>
> Which is why you either
> (a) note that papers studying priority inversion on RDBMS's
> find that it's
The sad reality from what I have observed is that unless more people gain
those skills and want to work in ops, it's becoming very hard for me to
justify recommending postgresql for enterprise (or larger) scale projects.
What do others do and/or experience?
I think there are peopl
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
---(end of broadcast)---
TIP 3: Have you checked
Tom Lane wrote:
Jesse Cleary <[EMAIL PROTECTED]> writes:
This script has been running successfully for several months (70-90 min each
night). Out of the blue I'm now getting the following error message after each
psql command, except the last vacuum full analyze command:
ERROR: could not
On 3/27/07, Steve Atkins <[EMAIL PROTECTED]> wrote:
Or SQL-on-rails
http://www.sqlonrails.org/
LOL!
merlin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 3/27/07, Erik Jones <[EMAIL PROTECTED]> wrote:
Not having looked myself, this is as much a question as a suggestion, but
are there not postgres dba training seminars/courses you could recommend
they send their dba's to?
There are some classes out there but in my opinion your best bet (from
p
On 27/03/2007 17:00, Tom Lane wrote:
I think you want just to_char(d.dates, 'FMmonth') and so on.
What you're invoking above is to_char(numeric) which has entirely
different format codes...
Duh! Of course.I didn't spot that.
Thanks to all who replied.
Ray.
--
David Brain <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
>> Hm, I don't see fk_cdrsummary_cdrimportsession in there anywhere?
> That is _very_ odd - I can see it in pgadmin, and also in pg_constraint,
> but it's not showing up in pg_dump or on a '\d' in psql.
Oh really? (looks at code...) Hah,
Oleg Bartunov wrote:
> On Tue, 27 Mar 2007, Bruce Momjian wrote:
>
> > Joshua D. Drake wrote:
> >> Peter Eisentraut wrote:
> >>> Oleg Bartunov wrote:
> Probably, it's time to sponsor our book-writers and other enthusiasts
> to write "PostgreSQL Administration handbook", which we (communi
hmm,
looks like checkpoint ?
Check checkpoint settings in postgresql.conf.
Oleg
On Tue, 27 Mar 2007, Dmitry Koterov wrote:
Hello.
I have found that sometimes heavy loaded PostgreSQL begins to run all the
queries slower than usual, sometimes - 5 and more times slower. I cannot
reprocude tha
On Mar 27, 2007, at 7:34 AM, Aidan Van Dyk wrote:
Kev wrote:
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P
out
of the LAMP (or in my case, WAMP for now) stack. What I mean is
having
eve
On Tue, 2007-03-27 at 08:54, Marc Evans wrote:
> Hello -
>
> Over the past couple of years I have made use of postgresql as my database
> of choice when developing new software. During that time, my clients have
> in multiple cases eventually come back to me and requested a re-targeting
> to "A
Jesse Cleary <[EMAIL PROTECTED]> writes:
> This script has been running successfully for several months (70-90 min each
> night). Out of the blue I'm now getting the following error message after
> each psql command, except the last vacuum full analyze command:
> ERROR: could not create relatio
Hello.
I have found that sometimes heavy loaded PostgreSQL begins to run all the
queries slower than usual, sometimes - 5 and more times slower. I cannot
reprocude that, but symptoms are the following: queries work very fast for
5-10 minutes, and after that - significant slowdown (every query, ev
Kev wrote:
> Hi everyone,
>
> I'm still in the design phase of a project. I was just wondering if
> anyone has any thoughts or experience on the idea of cutting the P out
> of the LAMP (or in my case, WAMP for now) stack. What I mean is
> having
> everything encapsulated into sql (or plpgsql or
On Tue, 27 Mar 2007, Bruce Momjian wrote:
Joshua D. Drake wrote:
Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write "PostgreSQL Administration handbook", which we (community)
will accept, support and translate to differe
a (possibly slightly more user-friendly) alternative to the catalog
table is pg_dump, e.g.:
pg_dump -d your_db_name -t your_table -s | grep 'CREATE INDEX'
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Dmitry Koterov
> Sent: Tuesday, March 2
Matthijs Melissen wrote:
I want two users to execute the following queries:
1) delete from forum where id = 'A';
1) insert into forum (id, name) values ('A', 'testa');
2) delete from forum where id = 'A';
2) insert into forum (id, name) values ('A', 'testb');
id is a unique key. The numbers de
Jesse Cleary <[EMAIL PROTECTED]> writes:
> One exception is notable - $PGDATA/base/835021/4294967264 - this file
> has a size of 0 and a timestamp that coincides with the date and time
> range of the nightly run when these errors first appeared. This seems
> like a good clue, but not sure what
On Tue, 27 Mar 2007, Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write "PostgreSQL Administration handbook", which we (community)
will accept, support and translate to different languages.
http://www.postgresql.org/docs
Raymond O'Donnell escreveu:
'Lo all,
I've created a calendar table based on an article I found on the web,
but I can't figure out what's wrong with the query I've written to
populate it. Here's the table -
CREATE TABLE aux_dates
(
the_date date NOT NULL,
the_year smallint NOT NULL,
the
"Raymond O'Donnell" <[EMAIL PROTECTED]> writes:
> to_char(extract (month from d.dates), 'FMmonth') as month_name,
> to_char(extract (day from d.dates), 'FMday') as day_name
I think you want just to_char(d.dates, 'FMmonth') and so on.
What you're invoking above is to_char(numeric) which h
Joshua D. Drake wrote:
> Peter Eisentraut wrote:
> > Oleg Bartunov wrote:
> >> Probably, it's time to sponsor our book-writers and other enthusiasts
> >> to write "PostgreSQL Administration handbook", which we (community)
> >> will accept, support and translate to different languages.
> >
> > http
Raymond O'Donnell wrote:
> to_char(extract (month from d.dates), 'FMmonth') as month_name,
> to_char(extract (day from d.dates), 'FMday') as day_name
These formatting patterns are invalid. Check the documentation for the
real ones.
--
Peter Eisentraut
http://developer.postgresql.org/~
Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write "PostgreSQL Administration handbook", which we (community)
will accept, support and translate to different languages.
http://www.postgresql.org/docs/current/static/admin.
Oleg Bartunov wrote:
> Probably, it's time to sponsor our book-writers and other enthusiasts
> to write "PostgreSQL Administration handbook", which we (community)
> will accept, support and translate to different languages.
http://www.postgresql.org/docs/current/static/admin.html
--
Peter Eisent
On 3/27/07, Oleg Bartunov wrote:
Marc,
I forwarded your message to pgsql-advocacy list.
The same situation in Russia ! I think, that the major problem here is
lack of "official" training courses on PostgreSQL and certificates.
"Official" mean something that was accepted by the PostgreSQL commun
Added to TODO:
* Allow configuration of backend priorities via the operating system
Though backend priorities make priority inversion during lock
waits possible, research shows that this is not a huge problem.
http://archives.postgresql.org/pgsql-general/2007-02/msg00493.php
'Lo all,
I've created a calendar table based on an article I found on the web,
but I can't figure out what's wrong with the query I've written to
populate it. Here's the table -
CREATE TABLE aux_dates
(
the_date date NOT NULL,
the_year smallint NOT NULL,
the_month smallint NOT NULL,
t
David Brain <[EMAIL PROTECTED]> writes:
> The db is now semi production, but I'll happily provide whatever info I
> can short of needing a restart (and even a restart could be scheduled if
> necessary).
> Let me know if I can provide any more info.
Can you send me the output of "pg_dump -s" (ie,
Marc,
I forwarded your message to pgsql-advocacy list.
The same situation in Russia ! I think, that the major problem here is
lack of "official" training courses on PostgreSQL and certificates.
"Official" mean something that was accepted by the PostgreSQL community.
This is a real pity, since w
Not sure I can provide one either I'm afraid, I don't think I did
anything unusual. But I can provide you with some background as to how
this DB was created so if you can see any steps that may have been
problematic.
This db was created as part of an upgrade to new hardware, using Slony
to r
Hi Kenneth,
This is wonderful news. I will definitely be checking into it as soon as I
have a moment. Thanks!
Kev
> Kev, we have a GPL'd product targeting Postgres that has significant
> overlap with what you want, though in other areas we went in another
> direction. The site is www.andro
> On 22 Mar 2007 14:58:15 -0700, Kev <[EMAIL PROTECTED]> wrote:
> > Hi everyone,
> >
> > I'm still in the design phase of a project. I was just wondering if
> > anyone has any thoughts or experience on the idea of cutting the P out
> > of the LAMP (or in my case, WAMP for now) stack. What I mean
On Mar 27, 2007, at 9:37 AM, Merlin Moncure wrote:
On 3/27/07, Marc Evans <[EMAIL PROTECTED]> wrote:
Hello -
Over the past couple of years I have made use of postgresql as my
database
of choice when developing new software. During that time, my
clients have
in multiple cases eventually co
Merlin Moncure wrote:
On 3/27/07, Randal L. Schwartz wrote:
> "Kenneth" == Kenneth Downs <[EMAIL PROTECTED]> writes:
Kenneth> This in effect makes the web server a proxy to the database,
which
Kenneth> sounds like what you are after. The "P" portion for us is
PHP, not
Kenneth> Perl, and
David Brain <[EMAIL PROTECTED]> writes:
> This could well be a recurrence of this issue:
> http://archives.postgresql.org/pgsql-general/2007-01/msg01801.php
> for which there doesn't seem to have been a resolution.
I never got a reproduceable case out of the other reporter ... can you
provide one?
Randal L. Schwartz wrote:
"Kenneth" == Kenneth Downs <[EMAIL PROTECTED]> writes:
Kenneth> This in effect makes the web server a proxy to the database, which
Kenneth> sounds like what you are after. The "P" portion for us is PHP, not
Kenneth> Perl, and it is small though non-zero.
On 3/27/07, Marc Evans <[EMAIL PROTECTED]> wrote:
Hello -
Over the past couple of years I have made use of postgresql as my database
of choice when developing new software. During that time, my clients have
in multiple cases eventually come back to me and requested a re-targeting
to "Any databas
On 3/27/07, Csaba Nagy <[EMAIL PROTECTED]> wrote:
> I agree with everything you said except the point about the GWT.
> Using a framework like this you can have your query in the javascript,
> and pass it through directly the database and pass the data back using
> extremely simple (think 10 line)
On 3/27/07, Randal L. Schwartz wrote:
> "Kenneth" == Kenneth Downs <[EMAIL PROTECTED]> writes:
Kenneth> This in effect makes the web server a proxy to the database, which
Kenneth> sounds like what you are after. The "P" portion for us is PHP, not
Kenneth> Perl, and it is small though non-z
Hello -
Over the past couple of years I have made use of postgresql as my database
of choice when developing new software. During that time, my clients have
in multiple cases eventually come back to me and requested a re-targeting
to "Any database that we (my client) can find skilled ops staff
Correction: my sever is running 8.1.3
Jaime Silvela wrote:
Just bringing back to life a message I sent last July.
The problem I was having was that when importing very large data sets,
COPY seemed to drop some data. I built a script to use INSERTs, and
same problem. My server runs 8.1.3 on Li
22 Mar 2007 17:01:20 -0700, Jaro <[EMAIL PROTECTED]>:
Hello
How create something like this:
UserName: user1 (he's root db_user1)
DatabaseName db_user1
UserName: user2 (he's root db_user2)
DatabaseName db_user2
I'd like create several users and several databases, ever user should
be root onl
Just bringing back to life a message I sent last July.
The problem I was having was that when importing very large data sets,
COPY seemed to drop some data. I built a script to use INSERTs, and same
problem. My server runs 8.1.3 on Linux. Several people investigated,
Reece Hart was unable to r
> "Kenneth" == Kenneth Downs <[EMAIL PROTECTED]> writes:
Kenneth> This in effect makes the web server a proxy to the database, which
Kenneth> sounds like what you are after. The "P" portion for us is PHP, not
Kenneth> Perl, and it is small though non-zero. It has only two jobs really.
Kennet
> I agree with everything you said except the point about the GWT.
> Using a framework like this you can have your query in the javascript,
> and pass it through directly the database and pass the data back using
> extremely simple (think 10 line) php or perl rpc that renders query
> result back in
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
> It seems that the legacy application creates tables dynamically and the
> number of the created tables depends on the size of the input of the
> application. For the specific input which generated that error I've
> estimated a number of created tabl
On 3/27/07, Peter Childs <[EMAIL PROTECTED]> wrote:
Strangely the in-house application is often still the better way to
go. The web can make everything 3 times more complicated than it needs
to be. Toolkits like GWT help this but you still need to write
"middleware" even when you can trust the tr
Kev, we have a GPL'd product targeting Postgres that has significant
overlap with what you want, though in other areas we went in another
direction. The site is www.andromeda-project.org, and I've put some
comments below:
Kev wrote:
Hi everyone,
I'm still in the design phase of a project.
Hi,
This could well be a recurrence of this issue:
http://archives.postgresql.org/pgsql-general/2007-01/msg01801.php
for which there doesn't seem to have been a resolution.
I am running:
PostgreSQL 8.1.5 on x86_64-pc-linux-gnu, compiled by GCC
x86_64-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.
Tom Lane wrote:
Jesse Cleary <[EMAIL PROTECTED]> writes:
This script has been running successfully for several months (70-90 min each
night). Out of the blue I'm now getting the following error message after each
psql command, except the last vacuum full analyze command:
ERROR:
On 27/03/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 22 Mar 2007 14:58:15 -0700, Kev <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I'm still in the design phase of a project. I was just wondering if
> anyone has any thoughts or experience on the idea of cutting the P out
> of the LAMP (or i
On 3/26/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
>I have to manage an application written in java which call another module
> written in java which uses Postgre DBMS in a Linux environment. I'm new to
> Postgres. The problem is that for large amo
On 22 Mar 2007 14:58:15 -0700, Kev <[EMAIL PROTECTED]> wrote:
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P out
of the LAMP (or in my case, WAMP for now) stack. What I mean is
having
everythin
On Tue, Mar 27, 2007 at 12:41:53PM +0200, Matthijs Melissen wrote:
> I get DELETE 0 even if a record with id=20 already exists before both
> transactions.
Transaction 2 (T2) is deleting the version of the row with id = 20
that was visible to T2 when it executed its DELETE. Since T1 deleted
that
I have a query that performs a multiple join between four tables and
that doesn't use the defined indexes.
If I set enable_seqscan to off, the query obviously uses the indexes and
it is considerable faster than normal planned execution with
enable_seqscan=true.
Can you give me a reason why Postgr
Alban Hertroys wrote:
Pavan Deolasee wrote:
On 3/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Matthijs Melissen" <[EMAIL PROTECTED]> writes:
I am executing the following queries (id has a unique key):
1) begin;
1) delete from forum where id = 20;
1) insert into forum (id, name) values (20, 'te
Pavan Deolasee wrote:
> On 3/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>>
>> "Matthijs Melissen" <[EMAIL PROTECTED]> writes:
>> > I am executing the following queries (id has a unique key):
>> > 1) begin;
>> > 1) delete from forum where id = 20;
>> > 1) insert into forum (id, name) values (20, 'te
Thanks!
*pg_indexes.indexdef* is exactly what I was looking for!
On 3/27/07, Erik Jones <[EMAIL PROTECTED]> wrote:
On Mar 26, 2007, at 5:24 PM, Dmitry Koterov wrote:
Hello.
I need to perform a mass operation (UPDATE) on each table row. E.g. -
modify one table column:
UPDATE tbl SET tbl_text
On 3/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Matthijs Melissen" <[EMAIL PROTECTED]> writes:
> I am executing the following queries (id has a unique key):
> 1) begin;
> 1) delete from forum where id = 20;
> 1) insert into forum (id, name) values (20, 'test');
> 2) delete from forum where id =
79 matches
Mail list logo
