On Wed, Feb 15, 2006 at 12:33:30AM -0500, Tom Lane wrote:
> The existence of duplicate timezone abbreviations is certainly a pain
> :-(. The solution I would like to see is to factor all the hardwired
> timezone abbreviations in datetktbl out into a configuration file that
> could be adjusted for
Within the same query. The function takes a tuple as its input
parameter. It will be used in the where clause. So I think it will be
called one time for each read tuple, right? I want to maintain a
structure to store the information about the tuples that have been
read so far. The output value of
On Wed, Feb 15, 2006 at 10:49:14AM +0100, andrew wrote:
> Within the same query. The function takes a tuple as its input
> parameter. It will be used in the where clause. So I think it will be
> called one time for each read tuple, right? I want to maintain a
> structure to store the information ab
Thanks. But it is a little different. What I want is one output value
of every input tuple. But the output value is not only based on the
current input value but also some value that have been read before.
On 2/15/06, Martijn van Oosterhout wrote:
> On Wed, Feb 15, 2006 at 10:49:14AM +0100, andre
Am 2006-02-09 11:13:22, schrieb Tyler MacDonald:
> Hmm, looks like a large noise:signal ratio there:
>
> http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/2005-November/thread.html
>
> In fact, I'd go as far as to say that list would make an excellent
> spam honeypot. ;-
I've started writing some scripts to set up incremental backup to my
taste. I just discovered something and thought I would revisit this
thread briefly.
When you go to restore from a give base file system backup you need
to know the start WAL file that you need and the end WAL file that
Hello, Is there a way do discover when was the last time a table or database vacuumed? Thanks in advance! Reimer
Yahoo! Acesso Grátis
Internet rápida e grátis. Instale o discador agora!
Hi All,
Sorry if this was answered before, I was unable to find anything in archives.
Here's a problem I'm facing:
I have a "mimetype" table with all mimetypes my app has to deal with. I'm in a
process of adding a fulltext indexing (tsearch2) into my DB and I want to
specify a per-mimetype con
On Wed, Feb 15, 2006 at 03:47:54PM +0200, Igor Shevchenko wrote:
> Here's a problem I'm facing:
>
> I have a "mimetype" table with all mimetypes my app has to deal with. I'm in
> a
> process of adding a fulltext indexing (tsearch2) into my DB and I want to
> specify a per-mimetype conversion fu
Martijn van Oosterhout writes:
> I really wish we could clear up this stuff with the australian
> timezones. I'd love a poll as to how often they're used because I don't
> think most people want them.
I think defining the problem as "let's get rid of australian_timezones"
would be a serious mista
andrew <[EMAIL PROTECTED]> writes:
> Within the same query. The function takes a tuple as its input
> parameter. It will be used in the where clause. So I think it will be
> called one time for each read tuple, right? I want to maintain a
> structure to store the information about the tuples that h
Tom ~
Thanks for yet another prompt and helpful response. May I submit a
follow-up question?
Briefly, what I'm trying to do is build a (web-front-ended) system that
translates a "now()" entry into a timestamptz column into "now" at a
specified time zone (which is looked up from the database).
"Ken Winter" <[EMAIL PROTECTED]> writes:
> Briefly, what I'm trying to do is build a (web-front-ended) system that
> translates a "now()" entry into a timestamptz column into "now" at a
> specified time zone (which is looked up from the database).
> Why? Say there's a payment deadline recorded
Marc G. Fournier wrote:
As of this moment, if Oracle buys Zend, they could effectively kill PHP
... the core engine that PHP is built around is a Zend engine, so if
they were to revoke the license for that, PHP would be dead ... kinda
like MySQL with InnoDB ... now, there was talk at one point
Steve Manes wrote:
Marc G. Fournier wrote:
As of this moment, if Oracle buys Zend, they could effectively kill
PHP ... the core engine that PHP is built around is a Zend engine, so
if they were to revoke the license for that, PHP would be dead ...
kinda like MySQL with InnoDB ... now, there wa
Comments inline.
On Wed, Feb 15, 2006 at 09:49:57AM -0500, Tom Lane wrote:
> I think defining the problem as "let's get rid of australian_timezones"
> would be a serious mistake. The basic problem here is that we can't
> have a one-size-fits-all list of timezone abbreviations. We've
> certainly
I have a fairly large (about 30Gb) PostgreSQL 8.1 database running on
Windows 2003 Server.
I noticed that CPU utilization on the server is 100% for past few days,
and postgres process is taking up most of that CPU (95%-100%). There is
only one connection to the database at the time and that one is
From pg_controldata
Latest checkpoint NextXID: 746940488
Under the database tree that is displayed in pgAdmin, when I click on
the database, an error dialog pops up with this message "An error has
occured: FATAL: database "db2" does not exist". Even if I disconnect and
reconnect, the database
Hello all,
I run a nightly "vacuumdb -a -z" on my production server. The output of
the command is emailed to me every night. Today while checking my email
I received this:
vacuumdb: vacuuming database "postgres"
vacuumdb: vacuuming of database "postgres" failed: ERROR: out of memory
DETAIL
Nik wrote:
> I noticed that CPU utilization on the server is 100% for past few
100% CPU usage is not a problem. When the number of waiting processes
goes up, then you have a reason to start being concerned.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
n 14 Feb 2006 06:46:48 -0800, Nik <[EMAIL PROTECTED]> wrote:
> I turned off stats collector, and any row stat collectors, and I
> increased the number of check points since I have been getting the
> error about check point switches being to frequent. Postgres now uses a
> bit less CPU (60-90%), wh
We tried this recently. You have to use lower(a) like lower(b) for
the index to work.
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED]
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G
"Matthew T. O'Connor" writes:
> no tables in it. I logged into my server and reran the vacuumdb -a -z
> command and it went though with no problem. I also checked my log file
> and it shows that there have been 25 out of memory errors on my server
> today.
> My question is: Is this normal?
Tom Lane wrote:
"Matthew T. O'Connor" writes:
PostgreSQL 8.1.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 20040412 (Red Hat Linux 3.3.3-7)
... and this should definitely make you nervous. We don't release
update versions for idle amusement. Get onto 8.1.3 and see if
> Is there a way do discover when was the last time a table or database
> vacuumed?
No, but you might look at the contrib pgstattuple function. The function
will give detailed information on the state of the table on disk.
michael
---(end of broadcast)--
Hello,
Looking for advice on creating as dynamic a datalogging scheme as I can
using plpgsql.
The idea would be to have a trigger function that I could drop on any
table in my database. Then on update, the function would iterate
through each field, and check to see if NEW. <>
OLD.. Then a fu
Hi,
We have a problem with PostgreSQL 8.1 on a production server (Windows
2003 Server, Xeon 3GHz, 1GB)); application placed on it run for a month
without problems. It was great. But yesterday...
Any connection to the server, from application or pgAdmin (both
previously working fine), is slow. I m
I am not concerned about Sleepycat revoking their open source license
for future versions of BDB. I am less concerned about them revoking
licenses for current and older releases. That would be impossible.
However this "deal" troubles me and I cant quite put my finger on why.
I'll try to tease it ou
On Wed, 2006-02-15 at 11:05, Chad wrote:
> I am not concerned about Sleepycat revoking their open source license
> for future versions of BDB. I am less concerned about them revoking
> licenses for current and older releases. That would be impossible.
> However this "deal" troubles me and I cant qu
Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase last year).
Does this mean the other shoe has dropped for MySQL AB?
I think th
On Feb 14, 2006, at 3:45 PM, Peter Eisentraut wrote:
http://dev.mysql.com/doc/refman/5.1/en/bdb-storage-engine.html
For kicks, I decided to read that... lead me to this page:
http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
I especially like the third restriction. How on earth
"Chad" <[EMAIL PROTECTED]> wrote:
"What we need now is an open source DB with clean APIs into various
places in the software stack (eg we need a Berkeley DB kind of API
under the hood into something like Postgres) A full bells and whistles
relational DB with these low level ACCESS APIs will be a p
On 2/15/06, Nikola Ivanov <[EMAIL PROTECTED]> wrote:
> I found the pid of the postgres process that was consuming all the CPU. I
> turned the stats back on (and reloaded the conf file), but when I query
> pg_stat_activity I get nothing back. No records.
did you restart server? I think stats colle
> I have a fairly large (about 30Gb) PostgreSQL 8.1 database
> running on Windows 2003 Server.
> I noticed that CPU utilization on the server is 100% for past
> few days, and postgres process is taking up most of that CPU
> (95%-100%). There is only one connection to the database at
> the time
Vivek Khera <[EMAIL PROTECTED]> writes:
> http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
> I especially like the third restriction. How on earth do people live
> with this software?
The preceding page is amusing too:
http://dev.mysql.com/doc/refman/5.1/en/bdb-todo.html
I find th
On Wed, 2006-02-15 at 14:34, TJ O'Donnell wrote:
> "Chad" <[EMAIL PROTECTED]> wrote:
> "What we need now is an open source DB with clean APIs into various
> places in the software stack (eg we need a Berkeley DB kind of API
> under the hood into something like Postgres) A full bells and whistles
>
I developed, and have been using, this[1] and it's been working fine for me. :)
http://open-ils.org/blog/?p=28
On 15 Feb 2006 10:10:29 -0800, rob <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>
> Looking for advice on creating as dynamic a datalogging scheme as I can
> using plpgsql.
>
>
> The idea wou
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom>* Change to use no page locks for table scanning operations.
Tom> Maybe I'm misunderstanding, but that sure sounds like they intend to
Tom> dumb down BDB so that it no longer works well in concurrent situations,
Tom> in order to save a f
Bart Golda wrote:
Hi,
We have a problem with PostgreSQL 8.1 on a production server (Windows
2003 Server, Xeon 3GHz, 1GB)); application placed on it run for a month
without problems. It was great. But yesterday...
Any connection to the server, from application or pgAdmin (both
previously working
On Tue, Feb 14, 2006 at 10:55:33AM -0500, Emi Lu wrote:
> May I know whether plpgsql supports "switch / case " or I have to use IF
> /ELSIF please?
http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGSQL-CONDITIONALS
does not list something like the switch / case constr
Well, in all fairness, MySQL probably gives the right answer most of the time,
always really fast (except for some use cases).
On Wed, 15 Feb 2006, Randal L. Schwartz wrote:
"Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> * Change to use no page locks for table scanning operations
On Wed, Feb 15, 2006 at 01:02:03PM -0800, Ben wrote:
> Well, in all fairness, MySQL probably gives the right answer most of the
> time, always really fast (except for some use cases).
"Probably gives the right answer most of the time."
I'm not sure whether to laugh or cry.
--
Michael Fuhr
---
On Wed, Feb 15, 2006 at 02:45:07PM -0600, Scott Marlowe wrote:
> Yeah, plus, besides PostgreSQL's front-end C api (libpqxx) there's the
> backend api, which can be programmed with the C language directly, and
> used to do things like write triggers and all that.
>
> I'm not sure what more Chad cou
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 15, 2006 10:25 AM
> To: [EMAIL PROTECTED]
> Cc: 'PostgreSQL pg-general List'
> Subject: Re: [GENERAL] Does PG really lack a time zone for India?
>
> "Ken Winter" <[EMAIL PROTECTED]> writes:
> > Brie
"Ken Winter" <[EMAIL PROTECTED]> writes:
> Yes, that's what I'm trying to do. My problem has been: how to enter the
> equivalent of '2006-02-15 10:22:46-05' when the time I want to enter and
> convert to EST is a variable value or now().
This still shows a problem in your grasp of what's going on
I am not able to successfully create an entry in the pg_hba.conf file to
enable remote access to my postgres database.
The postmaster process HAS been initialized to accept tcp/ip connections.
I have tried entering the following record in the file, but it does not
grant me access.
host all
Colin Shreffler <[EMAIL PROTECTED]> writes:
> I have tried entering the following record in the file, but it does not
> grant me access.
(1) did you remember to sighup the postmaster after changing the file?
(2) what error message do you get *exactly*? What shows up in the
postmaster log file?
Hello,
From Section 11.4 of the Postgres 8.1 documentation, a new optimization
is shipped in the latest release.
"... a query like WHERE x = 42 OR x = 47 OR x = 53 OR x = 99 could be
broken down into four separate scans of an index on x, each scan using
one of the query clauses. The results of t
Why doesn't mysql just forget the whole dual licensing of the server
thing and just tell everyone to use the GPL versions of everything.
Then dual license the client libraries which I would think they
already own outright. I think this is what forces most people to
need a commercial licen
"Jimmy Choi" <[EMAIL PROTECTED]> writes:
> I find that it doesn't work (i.e. index is not used and a sequential
> scan is needed), if I have the following instead:
> SELECT * FROM foo WHERE id = ANY (ARRAY[1,2]);
> Is this expected?
Yes. That construct isn't indexable, period, in any existing re
of interest perhaps...
http://news.zdnet.com/2100-9593_22-6040197.html?tag=zdnn.alert
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On 2006-02-15, "Jimmy Choi" <[EMAIL PROTECTED]> wrote:
> I find that it doesn't work (i.e. index is not used and a sequential
> scan is needed), if I have the following instead:
>
> SELECT * FROM foo WHERE id = ANY (ARRAY[1,2]);
>
> Is this expected? The reason I would like the last case to work
Quoth [EMAIL PROTECTED] (Rick Gigger):
> Why doesn't mysql just forget the whole dual licensing of the server
> thing and just tell everyone to use the GPL versions of everything.
> Then dual license the client libraries which I would think they
> already own outright. I think this is what forces
On Wednesday 15 February 2006 01:38, Tom Lane wrote:
> merlyn@stonehenge.com (Randal L. Schwartz) writes:
> > Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
> > "other" way that MySQL could have transactions if Oracle decided to
> > restrict InnoDB tables (after purchasing
On Thu, 16 Feb 2006, Leonard Soetedjo wrote:
On Wednesday 15 February 2006 01:38, Tom Lane wrote:
merlyn@stonehenge.com (Randal L. Schwartz) writes:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restr
On Wednesday 15 February 2006 01:38, Tom Lane wrote:
merlyn@stonehenge.com (Randal L. Schwartz) writes:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase la
* Chad ([EMAIL PROTECTED]) wrote:
> course the product you own is called "MySQL". Do MySQL or any MySQL
> customers need a commercial license for BDB? I think not. MySQL does
> not as all its code is open source. As for MySQL customers, unless they
> are making direct API calls into BDB (which most
Leonard Soetedjo wrote:
Is it possible that Oracle is trying to buy MySQL to kill off other open
source competitor, e.g. PostgreSQL? MySQL has a strong number of users and
therefore it is a good deal for Oracle to buy MySQL. Then by doing that,
Oracle will market MySQL as the low-end alternat
On Thursday 16 February 2006 10:15, Steve Manes wrote:
> Leonard Soetedjo wrote:
> > Is it possible that Oracle is trying to buy MySQL to kill off other open
> > source competitor, e.g. PostgreSQL? MySQL has a strong number of users
> > and therefore it is a good deal for Oracle to buy MySQL. The
And since MySQL already has got the upperhand in terms of marketing, Oracle
would buy MySQL to make it as the low-end alternative. Never mind the
lack/immature features in MySQL such as stored proc or trigger.
Mysql 5 has stored procedures and triggers.
The fact that you have to change betw
On Wednesday 15 February 2006 18:49, Chris wrote:
> > And since MySQL already has got the upperhand in terms of marketing,
> > Oracle would buy MySQL to make it as the low-end alternative. Never mind
> > the lack/immature features in MySQL such as stored proc or trigger.
>
> Mysql 5 has stored pro
Then, even if you do write something to use postgresql a lot of hosts
don't support it anyway ('mysql is good enough').. so you're stuck.
Well, I guess the moment all the hoster's have to buy commercial licenses for
providing a database they'll switch to PG in no time - or charge more for the
On Wednesday 2006-02-15 18:42, Leonard Soetedjo wrote:
> On Wednesday 15 February 2006 01:38, Tom Lane wrote:
> > merlyn@stonehenge.com (Randal L. Schwartz) writes:
> > > Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
> > > "other" way that MySQL could have transactions if
Chris <[EMAIL PROTECTED]> writes:
> eg mysql doesn't force you to group by all columns being selected - I
> can do:
> select field1, field2, field3 from table group by field1;
> and have it valid in mysql (but of course postgres will tell you it's
> not valid and need to add grouping for field2 a
Tom Lane wrote:
Chris <[EMAIL PROTECTED]> writes:
eg mysql doesn't force you to group by all columns being selected - I
can do:
select field1, field2, field3 from table group by field1;
and have it valid in mysql (but of course postgres will tell you it's
not valid and need to add grouping fo
Chris <[EMAIL PROTECTED]> writes:
> Quick test:
> create table a(a int primary key, b int, c varchar(200));
> insert into a(a, b, c) values (1,1,'one');
> insert into a(a, b, c) values (2,2,'two');
> insert into a(a, b, c) values (3,1,'one');
> insert into a(a, b, c) values (4,2,'two');
> mysql>
66 matches
Mail list logo
