On Wed, 26 Jan 2005 08:00:36 -0800, Max <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Our postgresql database is getting too big to be handled by one server. We
> need the database to be in RAM and cannot afford swapping. At the moment,
> we're using only 3GB or RAM, however our business growth is going
Tzahi Fadida <[EMAIL PROTECTED]> writes:
> I am writing an algorithm in a dynamic c library and using heap_fetch.
> I want to pin strategic buffers for long times like an Outer
> joins might do for the inner table.
> Do i to also need to lock the table somehow?
You didn't say enough about the co
Max wrote:
> Actually winXP and win server 2003 do support AMD64, it's intel 64
> that's not supported yet.
To be accurate, Windows AMD64 support is still in beta. There has been
a IA64 production release for quite some time, though Microsoft recently
announced that they were discontinuing it.
On Wed, 26 Jan 2005 10:59:44 +0200, Sim Zacks <[EMAIL PROTECTED]> wrote:
> The best and most flexible shopping cart I have ever used is Interchange,
> www.icdevgroup.org. It is open source and freely downloadable. I've had
> experience writing some custom discount functions and it was fairly simple
Tom Lane wrote:
Chris Travers <[EMAIL PROTECTED]> writes:
Maybe we should set the default authentication to only use TRUST on
local sockets only. At least as of 7.4, the default was to trust
network ports.
Perhaps you should check your facts before posting.
Ok. Pardon me. I misread
Hi,
I am writing an algorithm in a dynamic c library and using heap_fetch.
I want to pin strategic buffers for long times like an Outer
joins might do for the inner table.
Do i to also need to lock the table somehow?
I am only reading the tuple but maybe other transactions will
want to write to
On Wed, 26 Jan 2005 11:10:07 -0500, Frank D. Engel, Jr.
<[EMAIL PROTECTED]> wrote:
> I'm fairly certain there is currently no way to do this, but it would
So am I. :)
> Is there any way to expose a column in a view without "announcing" the
> fact that it is there? Specifically, in order to suppor
"Max" <[EMAIL PROTECTED]> writes:
> Here's a question for the developers: what's the memory consumption
> difference when you move a 3GB database from a 32 bit machine to a 64 ?
Not a lot.
> Isn't the whole data taking up more RAM because pointers are now 64 bits
> instead of 32 ?
There are no p
Max wrote:
And you absolutely want a 64-bit OS with that much memory. Even on our
development server with just 3GB of RAM, we see quite big jumps in
performance after moving from 32-bit Linux to 64-bit Linux. I'd hate to
think about 64GB of RAM being swapped in and out using PAE.
What's PAE ?
32-b
On Sat, Jan 29, 2005 at 22:24:46 +0300,
"Andrey V. Semyonov" <[EMAIL PROTECTED]> wrote:
> Hi there.
> How do I create a sequence of type inet for automatic assignment an
> IP/32 to a new row?
> Neither nextval() nor CREATE SEQUENCE seem for me to work with type inet
> (PostgreSQL 8.0.0, pgAdmin I
Andre Schnoor wrote:
Hi,
I'm moving from Sybase to pgsql but have problems with stored procedures.
The typical procedure uses
a) named parameters,
b) local variable declarations and assignments
c) transactions
d) cursors, views, etc.
I can't seem to find these things in the Postgres function syntax
On Sat, 29 Jan 2005 22:24:46 +0300, Andrey V. Semyonov <[EMAIL PROTECTED]>
wrote:
> Hi there.
> How do I create a sequence of type inet for automatic assignment an
> IP/32 to a new row?
> Neither nextval() nor CREATE SEQUENCE seem for me to work with type inet
> (PostgreSQL 8.0.0, pgAdmin III v 1.
postgresql-8.0.0beta4 $ time make -j 5
... lots of output ...
real0m41.274s
user1m36.315s
sys 0m15.451s
Yikes.
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Thu, Jan 27, 2005 at 05:54:24 -0800,
Anil <[EMAIL PROTECTED]> wrote:
>
> I inserted a new DB with somewhere around 200 tables and each table
> having some 100 entries. The table insertion went fine.
> But I wanted to know whether the DB is perfect ...I mean my DB is not
> corrupted. Are there
On Sat, Jan 29, 2005 at 02:35:06PM -0700, Michael Fuhr wrote:
> CREATE FUNCTION bigint2inet(bigint) RETURNS inet AS '
> BEGIN
> RETURN cidr(''0x'' || lpad(to_hex($1), 8, ''0''));
> END;
> ' LANGUAGE plpgsql IMMUTABLE STRICT;
I should point out that the above function is intended only as a
tri
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of PFC
> Sent: Saturday, January 29, 2005 1:25 PM
> To: Max; PgSql General
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
>
> > I have never heard of Propolice SSP. What is it ? Any relatio
On Sat, Jan 29, 2005 at 10:40:56PM +0300, Andrey V. Semyonov wrote:
> How do I create a sequence of type inet for automatic assignment an
> IP/32 to a new row?
Sequences values are bigints, so you'd have to convert a bigint to
inet or cidr. I don't see any built-in casts between numeric
types an
On Sat, 29 Jan 2005 21:18:38 +0100, PFC <[EMAIL PROTECTED]> wrote:
[snip]
> I wonder how long your killer machine will take to compile the whole
> OS.
> And Postgres too... could you post that ?
Well, I can't rebuild the whole OS (I'm using the box ... ) but:
postgresql-8.0.0beta4 $ ti
I have never heard of Propolice SSP. What is it ? Any relation to the
honey
'Propolys'. just kidding.
Max
The name says little although I like it.
http://www.gentoo.org/proj/en/hardened/
I was out of date -- Propolice has been renamed PaX.
The hardened project has many parts, you should r
> And you absolutely want a 64-bit OS with that much memory. Even on our
> development server with just 3GB of RAM, we see quite big jumps in
> performance after moving from 32-bit Linux to 64-bit Linux. I'd hate to
> think about 64GB of RAM being swapped in and out using PAE.
>
What's PAE ?
Here
>
> I won't say anything on linux vs windows performance
> (although I sure do
> have an opinion), but simply keep in mind that postgres on window
> is young
> and postgres on linux is vary mature ; therefore one is likely to have a
> lot more performance refinements than the other.
This is
Anders Sutinen wrote:
i am currently porting from oracle to postgres and i cant seem to find
anything equivalent to oracles greatest and least functions,
any help appreciated,
plz reply straight to my e-mail as i am not yet on the list,
This one has come up a few times before. See:
http://archive
On Sat, 29 Jan 2005 21:55:23 +0200, raptor <[EMAIL PROTECTED]> wrote:
> hi,
> how can I dump the db schema so that I can recrate the DB later ?
>From 'man pg_dump':
-s
--schema-only
Dump only the schema (data definitions), no data.
--
~
Thanks for reminding me that 64bit translates to: recompile everything
you
need!
I think this is exactly the choice of configuration we are going to make.
Someone just reminded me that windows and linux come down to the same
performance, but that the real overhead is on maintenance. It's true th
Max wrote:
That would be quite an investment. Interesting. I wonder if we should put
windows or linux on it, since postgresql 8.0 works on windows.
What OS are you running on your quad opteron ?
Well here's one thing that you can bank on. You can get 64-bit Linux now
while 64-bit Windows is still
Hi,
i am currently porting from oracle to postgres and i cant seem to find
anything equivalent to oracles greatest and least functions,
any help appreciated,
plz reply straight to my e-mail as i am not yet on the list,
regards,
Anders
---(end of broadcast)-
You're going to need a cursor or a for loop. No way to join them.
""Thomas Chille (spoon)"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> i have the following SQL-Problem:
>
> We are using 2 tables. The first, called plan, is holding planned working
times for employees per
hi,
how can I dump the db schema so that I can recrate the DB later ?
tia
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
The best and most flexible shopping cart I have ever used is Interchange,
www.icdevgroup.org. It is open source and freely downloadable. I've had
experience writing some custom discount functions and it was fairly simple.
Other then that I used it mostly out of the box.It has a great user
interface
Hi... People,
I wanna know how can i know inside of a function what the trigger
called, i mean which instruction SQL it called. I do not wanna know if
it´s a insert, update or delete (tp_op), i need to know the complete
instruction.
For example, i need to know something like this:
update phones
Hi there.
How do I create a sequence of type inet for automatic assignment an
IP/32 to a new row?
Neither nextval() nor CREATE SEQUENCE seem for me to work with type inet
(PostgreSQL 8.0.0, pgAdmin III v 1.2.0).
---(end of broadcast)---
TIP 8: explain
Hi,
I am using PSQL on RedHat Linux 6.2...version given below.
[PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.6]
I inserted a new DB with somewhere around 200 tables and each table
having some 100 entries. The table insertion went fine.
But I wanted to know whether the DB is pe
On Wed, Jan 26, 2005 at 10:42:07PM +0100, Pavel Stehule wrote:
> Hello,
>
> this is questions for hackers. Is possible put SRF functions more
> informations about context of calling SRF function? Not now. I
> know, but in future. For example: I have heavy SRF function which
> returns more thau
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> Sent: Saturday, January 29, 2005 11:01 AM
> To: Max
> Cc: PgSql General
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> On Sat, 29 Jan 2005 09:55:15 -0800, Max <[EMAIL PROT
I don't know how this works for a view, but in the ODBC driver settings
there is an option on page 2 to show the OID column. I am using linked
tables in Access and it does not show the OID column because the checkmark
is not clicked. I would suspect it works the same for views.
In any case, in ord
Hi there.
How do I create a sequence of type inet for automatic assignment an
IP/32 to a new row?
Neither nextval() nor CREATE SEQUENCE seem for me to work with type inet
(PostgreSQL 8.0.0, pgAdmin III v 1.2.0).
---(end of broadcast)---
TIP 6: Have y
Hi,
I'm moving from Sybase to pgsql but have problems with stored procedures.
The typical procedure uses
a) named parameters,
b) local variable declarations and assignments
c) transactions
d) cursors, views, etc.
I can't seem to find these things in the Postgres function syntax.
Procedures can b
Well, I haven't tried it yet, but I don't believe it will. It will be the same
connection in the same transaction. In other triggers, I've done something
similiar by inserting a record into a special table called "override" and
have other triggers that fire in the same transaction look for a rec
On Sat, 29 Jan 2005 09:55:15 -0800, Max <[EMAIL PROTECTED]> wrote:
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> > Sent: Friday, January 28, 2005 4:02 AM
> > To: Max; PgSql General
> > Subject: Re: [GENERAL] Splitting querie
On Sat, 2005-01-29 at 13:21 -0500, Terry Lee Tucker wrote:
[on prompting user in the middle of a transaction]
> Thanks for the reply, Tom. I just had an idea about writting the answer from
> the client to a table designed for that purpose. It could have a unique key
> as the pid and a column fo
isn't it possible to restrict UPDATE by access rights based on the DB's
user?
Create table with owner set to the administrator of the database (NOT
PostgreSQL SERVER!!!) and grant only the needed rights (or none of them)
to the user from which the usual processing of the database will be
perfo
Chris,
> Maybe we should set the default authentication to only use TRUST on
> local sockets only. At least as of 7.4, the default was to trust
> network ports.
If you know of a PostgreSQL package, from any source, that installs with trust
on network ports, please notify Core (and Core only, pl
Thanks for the reply, Tom. I just had an idea about writting the answer from
the client to a table designed for that purpose. It could have a unique key
as the pid and a column for storing the answer. When the notice receiver
returns, I could have the function check for the answer in the table.
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> > Sent: Friday, January 28, 2005 4:02 AM
> > To: Max; PgSql General
> > Subject: Re: [GENERAL] Splitting queries across servers
> >
> >
> > On Thu, 27 Jan 2005 20:17:29 -0800, Max <[
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Dann Corbit
> Sent: Friday, January 28, 2005 12:01 PM
> To: William Yu; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> Suppose that you currently need 16 GB t
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of William Yu
> Sent: Friday, January 28, 2005 11:36 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> Without memory, the prices are roughly:
>
> 4x846 =
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> Sent: Friday, January 28, 2005 4:02 AM
> To: Max; PgSql General
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> On Thu, 27 Jan 2005 20:17:29 -0800, Max <[EMAIL PROTECTED]>
please, i need to connect postgreSQL with ADODB
i have a driver ado, but i only see a message error
how do you connect postgreSQL with Visual Fox?
-
Profesiones con futuro: Electrónica, restauración, veterinaria, turismo...
¡Encuentra tu
Andre Schnoor wrote:
"Joshua D. Drake" wrote:
Andre Schnoor wrote:
Hi,
I am moving from Sybase to pgsql but have problems with stored procedures.
The typical procedure uses
a) named parameters,
b) local variable declarations and assignments
c) transactions
d) cursors, views, etc.
I can't seem to f
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> Is there any way to gather input from a user while in the
> middle of a transaction from a plpgsql function?
Hmm ... RAISE NOTICE to send out the prompt, and then COPY from some
pre-agreed file to collect the result? (COPY FROM STDIN would be nicer
Chris Travers <[EMAIL PROTECTED]> writes:
> Maybe we should set the default authentication to only use TRUST on
> local sockets only. At least as of 7.4, the default was to trust
> network ports.
Perhaps you should check your facts before posting.
regards, tom lane
---
In reply to my own question, and to pose a possible solution, and to query the
list as to whether anybody thinks I'm on the right track, would the following
excerpt from the documentation be a way of addressing this?
27.9. Notice Processing
Notice and warning messages generated by the server ar
Greetings List,
I am working on converting a large set of code from a commercial 4gl known as
Progress to plpgsql. This code defines a rating system for a transportation
logistics package. In the Progress world, one is able to prompt the user for
input during the execution of a trigger or a fun
On Sat, Jan 29, 2005 at 00:34:07 -0800,
Chris Travers <[EMAIL PROTECTED]> wrote:
>
> Maybe we should set the default authentication to only use TRUST on
> local sockets only. At least as of 7.4, the default was to trust
> network ports.
I believe the previous default was not to allow network
Tom Lane wrote:
The correct place for a sysadmin to limit memory usage would be in the
ulimit settings the postmaster starts under. Of course, Neil's argument
still holds in general: anyone who can write arbitrary queries is not
going to have any difficulty in soaking up unreasonable amounts of
re
Cross-posting to general due to more general nature of response
Josh Berkus wrote:
Chris,
http://www.theregister.co.uk/2005/01/28/mysql_worm/
Yep. And each time someone asks you "But why can't I install PostgreSQL as
Administrator" you can point them to that worm
Now, if Postgre
56 matches
Mail list logo
