"Scott Marlowe" <[EMAIL PROTECTED]> writes:
>> How much slower are numerics? And why (I guess it has
>> to do with potentially different sizes)?
> I think that there was a time when numerics were MUCH slower than =
> floats, but looking at a very simple benchmark I just threw together, =
> I'd say
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> The only way I know of to get row length info for certain is vacuum full
> verbose:
See also contrib/pgstattuple.
regards, tom lane
---(end of broadcast)---
TIP 1: if posting/read
On 22 Oct 2005, at 01:25, Edoceo Lists wrote:
List,
I've got a problem where I need to make a table that is going to
grow by an average of 230,000 records per day. There are only 20
columns in the table, mostly char and integer. It's FK'd in two
places to another table for import/expor
On Fri, Oct 21, 2005 at 05:25:22PM -0700, Edoceo Lists wrote:
[summary of situation]
> Some queries take more than five minutes to complete and I'm sad
> about that. How can I make this faster?
You might get more help on pgsql-performance, which is specifically
for discussions of performance is
List,
I've got a problem where I need to make a table that is going to grow by an average of 230,000 records per day. There
are only 20 columns in the table, mostly char and integer. It's FK'd in two places to another table for import/export
transaction id's and I have a serial primary key an
Magnus,
I have replied to general as well as the only mailing list I could find
on PG Foundry for pginstaller was the Devel list.
I actually do have all those files - the trouble is that the name
changes make pg_restore fail on a dump from a 8.0.3 Database with
spatial (postgis) tables.
Pos
The problem described below in 7.4.x, does not occur in 8.0.4, even with
near-simultaneous VACUUMs and updating. Previously, if one VACUUM was
run within a minute or two of the other, the problem below occurred.
-- Dean
On 2005-09-19 09:26, Dean Gibson (DB Administrator) wrote:
Simultaneous V
unsubscribe
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Changed your email format from HTML to plain text, which is preferred on
most mailing lists.
Redefined Horizons wrote:
> I'm running the latest stable version of PostgreSQL on a Debian Linux
> box running Gnome 2.0. I've just started setting up my first database
> with PostgreSQL and I've got a fe
Redefined Horizons <[EMAIL PROTECTED]> writes:
> I'm running the latest stable version of PostgreSQL on a Debian Linux box
> running Gnome 2.0. I've just started setting up my first database with
> PostgreSQL and I've got a few newbie questions:
I'm going to assume you installed the Debian packag
Title: RE: [GENERAL] How much slower are numerics?
-Original Message-
From: [EMAIL PROTECTED] on behalf of CSN
Sent: Fri 10/21/2005 5:30 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How much slower are numerics?
Another thing I've always wondered about ;), as I use
numerics
On Wed, Oct 19, 2005 at 08:23:35AM +0900, Michael Glaesemann wrote:
>
> On Oct 19, 2005, at 2:29 , vittorio wrote:
>
> >Using psql how can I ask postgresql to show the actual number of
> >rows of a
> >table?
>
> For table foo,
>
> select count(*) from foo;
>
> An up-to-date count of the numb
I'm running the latest stable version of PostgreSQL on a Debian Linux box running Gnome 2.0. I've just started setting up my first database with PostgreSQL and I've got a few newbie questions:
[1] Is there a way to determine where all the parts of my defualt PostgreSQL installation are located?
CSN <[EMAIL PROTECTED]> writes:
> Another thing I've always wondered about ;), as I use
> numerics far more than floats. From the docs:
>
> "However, arithmetic on numeric values is very slow
> compared to the integer types, or to the
> floating-point types"
>
> How much slower are numerics? And w
Another thing I've always wondered about ;), as I use
numerics far more than floats. From the docs:
"However, arithmetic on numeric values is very slow
compared to the integer types, or to the
floating-point types"
How much slower are numerics? And why (I guess it has
to do with potentially diffe
On Mon, Oct 17, 2005 at 04:42:15PM -0700, Jared Evans wrote:
> Is there a way for me to quickly calculate the maximum size of a row
> for a table? I wanted to know if there was an automatic way to do it
> before I do it manually.
Well, if the table is well-vacuumed, SELECT relpages*8192/reltuples
Chris Browne <[EMAIL PROTECTED]> writes:
> MaXX <[EMAIL PROTECTED]> writes:
>> An error string in the source code stands:
>> "cannot have more than 2^32-1 commands in a transaction"
> That means you couldn't do more than 2^32-1 INSERT statements.
Right.
> But that wouldn't (in principle) prevent
MaXX <[EMAIL PROTECTED]> writes:
> jeff sacksteder wrote:
>
>> Are there known limits to how many rows can be inserted by one
>> transaction, or does that just reflect the already documented row, table
>> and database limits?
> An error string in the source code stands:
> "cannot have more
On Fri, Oct 21, 2005 at 11:58:07AM -0700, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I'm looking into PostgreSQL. Coming from a MySQL background, I have
> made heavy use of its very useful GROUP_CONCAT function. You can
> read about the function here:
>
> http://dev.mysql.com/doc/refman/4.1/en/group
"Guy Rouillier" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> No, it's a feature, as per extensive discussion some time ago when we
>> made it do that. The general rule is that trailing spaces in a
>> char(n) are semantically insignificant.
> How did you reach the opposite conclusion for var
<[EMAIL PROTECTED]> writes:
> I'm looking into PostgreSQL. Coming from a MySQL
> background, I have made heavy use of its very useful
> GROUP_CONCAT function. You can read about the function
> here:
> http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
> Is there a PostgreSQL alternative
On Fri, Oct 21, 2005 at 11:49:54AM -0700, Steve Atkins wrote:
> SELECT email FROM customer
>WHERE email !~*
> '[EMAIL PROTECTED]@(?:[EMAIL
> PROTECTED])?[a-z0-9_-]+\.(?:a[defgilmnoqrstuwz]|b[abdefghijmnorstvwyz]|c[acdfghiklmnoruvxyz]|d[ejkmoz]|e[ceghrst]|f[ijkmorx]|g[abdefhilmnpqrstuwy]|h
Tom Lane wrote:
> Alex Turner <[EMAIL PROTECTED]> writes:
>> It appears that casting to a char() causes spaces to be stripped
>> (ignored) from the string:
> mls=# select length('123 '::char(8));
> length
>
> 3
> (1 row)
>
>> I'm not sure about anyone else, but I would personaly consider
> Hi all,
>
> I'm looking into PostgreSQL. Coming from a MySQL background,
> I have made heavy use of its very useful GROUP_CONCAT
> function. You can read about the function
> here:
>
> http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
>
> Is there a PostgreSQL alternative to GR
Seems like WAL backup is the way to go with PITR. database will not have to be exhaused over and over with pg_dump and if I do rsync hourly, I could minimize the network traffic significantly as well. I already like the term 'hot standby' from the doc already.
Thanks for your help.
-apu
On 10/
On Fri, 2005-10-21 at 13:38, Scott Marlowe wrote:
> On Fri, 2005-10-21 at 12:22, Apu Islam wrote:
> > I need suggestion to backup my postgresql server. The database is
> > growing 1/2 Gb a day and I am looking for a solution that would push
> > the data off to the backup server periodically with mi
Hi all,
I'm looking into PostgreSQL. Coming from a MySQL
background, I have made heavy use of its very useful
GROUP_CONCAT function. You can read about the function
here:
http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
Is there a PostgreSQL alternative to GROUP_CONCAT?
Thanks,
K
> I don't know whether I should be posting to Hacker Win 32 or
> General, but I wanted to ask if anyone else has experienced
> troubles restoring a DB on windows to 8.1 from 8.0.x when the
> DB contains GIS tables.
That really should go on the pginstaller list. Copying there.
> As far as I ca
On Fri, Oct 21, 2005 at 08:15:23PM +0300, Andrus wrote:
> I tried
>
> SELECT email FROM customer
> WHERE email !~
> '/[EMAIL PROTECTED]@(?:[EMAIL
> PROTECTED])?[a-z0-9-_]+\.(?:a[defgilmnoqrstuwz]|b[abdefghijmnorstvwyz]|c[acdfghiklmnoruvxyz]|d[ejkmoz]|e[ceghrst]|f[ijkmorx]|g[abdefhilmnpqrstu
On Fri, Oct 21, 2005 at 08:15:23PM +0300, Andrus wrote:
> >> How to write a WHERE clause which selects e-mail addresses which
> >> are surely wrong ?
> >
> > ... WHERE email !~ '...insert previously mentioned regex here...';
>
> Steve,
>
> thank you.
>
> I tried
[snip]
SELECT email FROM cu
On Fri, 2005-10-21 at 12:22, Apu Islam wrote:
> I need suggestion to backup my postgresql server. The database is
> growing 1/2 Gb a day and I am looking for a solution that would push
> the data off to the backup server periodically with minimal amount of
> load to the server (I am trying to avoid
On 10/21/05, Zlatko Matić <[EMAIL PROTECTED]> wrote:
> I was reading release notes for 8.1 and there is something about changes
> concerning replacing ::text with ::regclass in default clauses. There is a
> query in Release notes, that should be executed to update dump from previos
> versions.
> B
* Apu Islam ([EMAIL PROTECTED]) wrote:
> I need suggestion to backup my postgresql server. The database is growing
> 1/2 Gb a day and I am looking for a solution that would push the data off to
> the backup server periodically with minimal amount of load to the server (I
> am trying to avoid table
Am Freitag, den 21.10.2005, 12:22 -0500 schrieb Apu Islam:
> I need suggestion to backup my postgresql server. The database is
> growing 1/2 Gb a day and I am looking for a solution that would push
> the data off to the backup server periodically with minimal amount of
> load to the server (I am tr
Apu Islam <[EMAIL PROTECTED]> writes:
> I need suggestion to backup my postgresql server. The database is growing
> 1/2 Gb a day and I am looking for a solution that would push the data off
> to the backup server periodically with minimal amount of load to the
> server (I am trying to avoid table
Hrm, I thought there was something equivalent to an is_number()
function, which would have made this easy:
CASE WHEN is_number(x) THEN x ELSE NULL END;
But I can't seem to find one. Is there a historic reason such functions
don't exist?
On Mon, Oct 17, 2005 at 01:05:17PM -0700, TJ O'Donnell wrot
I need suggestion to backup my postgresql server. The database is growing 1/2 Gb a day and I am looking for a solution that would push the data off to the backup server periodically with minimal amount of load to the server (I am trying to avoid table locking). I am thinking to use rsync to sync th
On Fri, Oct 21, 2005 at 04:01:12PM +, Franck Coppola wrote:
> would be interested too : i don't feel very confident with slony).
Why don't you? (The Slony developers would like to know, I think.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions
>> How to write a WHERE clause which selects e-mail addresses which
>> are surely wrong ?
>
> ... WHERE email !~ '...insert previously mentioned regex here...';
Steve,
thank you.
I tried
SELECT email FROM customer
WHERE email !~
'/[EMAIL PROTECTED]@(?:[EMAIL
PROTECTED])?[a-z0-9-_]+\.(?:
Alex Turner <[EMAIL PROTECTED]> writes:
> It appears that casting to a char() causes spaces to be stripped (ignored)
> from the string:
mls=# select length('123 '::char(8));
length
3
(1 row)
> I'm not sure about anyone else, but I would personaly consider that a bug?
No, it's a feature,
> e any tools to do this ? (I would prefer opensource, but if
> there is a well proven and affordable commercial app to do it, why
> not).
What is your application written in?
>
> Sincerly,
>
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting,
Hello,
I was reading release notes for 8.1 and there is
something about changes concerning replacing ::text with ::regclass in default clauses. There is a query in Release
notes, that should be executed to update dump from previos
versions.
But, even without it, I see that all serial
filed
First, you should not quote an integer value going into an integer column -
bad habit to get into.
Second, empty string is not an integer.
Susan
On Fri, Oct 21, 2005 at 08:29:44PM +0530, surabhi.ahuja wrote:
> i have a fiels - varchar(100)
>
> to this fiels i am trying to insert
>
> "abc\def\xyz'
>
> but it is not inserting the whole thing ...
See "String Constants" in the documentation and take particular
note of what it says regar
double the backslashes. They are an escape
character.
--Larry
Rosenman
http://www.lerctr.org/~lerPhone: +1
972-414-9812
E-Mail: ler@lerctr.orgUS Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611
US
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
On Fri, 2005-10-21 at 11:01, Franck Coppola wrote:
> Hi,
>
> We have a postgresql database which we would like to clusterize. By
> clusterize, i mean be able to use multiple servers to read and write in
> the database. Simple replication is not enough. (However if you have any
> suggestion for re
i have a fiels - varchar(100)
to this fiels i am trying to insert
"abc\def\xyz'
but it is not inserting the whole thing
...
how can i ensure that the whole string including
the backslashes get inserted into the table
thanks
regards
surabhi
On Fri, 2005-10-21 at 03:14, Hannes Dorbath wrote:
> On 20.10.2005 23:02, John G. Eggert wrote:
> > I've also tried downloading the source with no success either.
>
> We do it all the time, we have at least 4 FreeBSD machines running 8.0.4
> here. Never had a problem installing / compiling. I did
It appears that casting to a char() causes spaces to be stripped (ignored) from the string:
mls=# select length('123 '::char(8));
length
3
(1 row)
mls=# select length('123 '::char(8)::varchar(8));
length
3
(1 row)
but:
mls=# select length('123 '::varchar(8
[EMAIL PROTECTED] writes:
> On Thursday 20 October 2005 23:48, Tom Lane wrote:
>> Give us a test case to demonstrate this assertion. It works as expected
>> AFAICT.
> Ok, it has to do with C functions:
> create or replace function plg_cfie() returns void as '/tmp/plg_cfie.so'
> language c immut
Patrick TJ McPhee schrieb:
In article <[EMAIL PROTECTED]>,
Roger Hand <[EMAIL PROTECTED]> wrote:
% If pg outputs a simple xml format, it can easily be transformed via xslt
% into OpenDoc table format, alternate html formats, or the alternate xml
% format of your choice.
Well, pg does output a
> Hi.
> I was installing postgresql 8.0 and let it generate a
> password for me, then i changed my mind and went back to
> change the password, but then i was stuck. How do i find the
> password it generated for me? How do i change it? How can i
> start over and install postgresql somehow? Than
Hi,
We have a postgresql database which we would like to clusterize. By
clusterize, i mean be able to use multiple servers to read and write in
the database. Simple replication is not enough. (However if you have any
suggestion for replication which are fit for production environements, i
would
What
platform? Solaris, FreeBSD, Linux, Windows
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Michael
UvhagenSent: Friday, October 21, 2005 6:10 AMTo:
pgsql-general@postgresql.orgSubject: [GENERAL]
passwordHi.I was installing po
jeff sacksteder <[EMAIL PROTECTED]> writes:
> Are there known limits to how many rows can be inserted by one transaction,
> or does that just reflect the already documented row, table and database
> limits?
Offhand I think the only limit that might concern you is the CID limit
of 2^32 SQL commands
jeff sacksteder wrote:
> Are there known limits to how many rows can be inserted by one
> transaction, or does that just reflect the already documented row, table
> and database limits?
An error string in the source code stands:
"cannot have more than 2^32-1 commands in a transaction"
(#:
Hi.
I was installing postgresql 8.0 and let it generate a password for me,
then i changed my mind and went back to change the password, but then i
was stuck. How do i find the password it generated for me? How do i
change it? How can i start over and install postgresql somehow? Thanks!
/Mike
In article <[EMAIL PROTECTED]>,
Roger Hand <[EMAIL PROTECTED]> wrote:
% If pg outputs a simple xml format, it can easily be transformed via xslt
% into OpenDoc table format, alternate html formats, or the alternate xml
% format of your choice.
Well, pg does output a simple xml format, which can
On Fri, Oct 21, 2005 at 11:41:15AM +0200, Janning Vygen wrote:
> I really would like to start it! Two reasons for me not to do it: I don't
> speak english very well, technical writing is even worse as my native
> language is german. Second: i have experience with postgresql for 5 years,
> but i
On Thursday 20 October 2005 23:48, Tom Lane wrote:
> Give us a test case to demonstrate this assertion. It works as expected
> AFAICT.
>
Ok, it has to do with C functions:
#include
#include
#include
PG_FUNCTION_INFO_V1(plg_cfie);
Datum
plg_cfie(PG_FUNCTION_ARGS)
{
struct timeval befo
Nicolas Barbier wrote:
On 10/21/05, Richard Huxton wrote:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be able to roll back
On Fri, Oct 21, 2005 at 12:25:36PM +0200, Nicolas Barbier wrote:
> On 10/21/05, Richard Huxton wrote:
> > jeff sacksteder wrote:
> > > Are there known limits to how many rows can be inserted by one
> > > transaction,
>
> > Well, the system will need to be able to roll back the transaction, ...
>
On 10/21/05, Richard Huxton wrote:
> jeff sacksteder wrote:
>
> > Are there known limits to how many rows can be inserted by one transaction,
> > or does that just reflect the already documented row, table and database
> > limits?
>
> Well, the system will need to be able to roll back the transac
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be able to roll back the transaction, so
at some point your system will grind to a h
I don't know whether I should be posting to Hacker Win 32 or General,
but I wanted to ask if anyone else has experienced troubles restoring a
DB on windows to 8.1 from 8.0.x when the DB contains GIS tables.
As far as I can see I don't have the postgis dll files or sql script,
but other parts o
Am Donnerstag, 20. Oktober 2005 19:59 schrieb David Fetter:
> On Thu, Oct 20, 2005 at 06:04:53PM +0200, Janning Vygen wrote:
> > By the way: What i really miss is a troubleshooting document in the
> > docs.
> > > That's a great idea. Please post a doc patch with some of the
> > > troubleshooting
On Thursday 20 October 2005 23:48, Tom Lane wrote:
> Give us a test case to demonstrate this assertion. It works as expected
> AFAICT.
>
Indeed it does. I forgot to mention that the first function to be called was
language plruby. Maybe that has anything to do with it.
I'll try to come with somet
Are there known limits to how many rows can be inserted by one
transaction, or does that just reflect the already documented row,
table and database limits?
On 20.10.2005 23:02, John G. Eggert wrote:
I've also tried downloading the source with no success either.
We do it all the time, we have at least 4 FreeBSD machines running 8.0.4
here. Never had a problem installing / compiling. I didn't use the ports
system though..
--
Regards,
Hannes Dor
On Fri, 21 Oct 2005, surabhi.ahuja wrote:
> i have a stored procedure
>
> insert_table(integer)
> which does "insert into table (x) value ($1)";
>
> now in my client i call the stored procedure as
>
> select insert_table("3");
>
> it works fine and inserts 3 into the table
>
> but suppose i give
70 matches
Mail list logo