On Fri, Nov 23, 2007 at 04:51:53PM -0800, Eric Davies wrote:
> I've got a server function that returns a set of HeapTuples. The
> server function is invoked in a query sent by a libpq client.However,
> I haven't spotted a way to decompose the HeapTuple returned to the
> client. Attempts to call Get
I will build a cheap server and I'm in doubt about what would the the
best for performance:
1 - everything in one lonely fast 10,000 rpm Raptor HD;
2 - two cheap 7,200 rpm 16MB cache HDs like this:
disk 1 - system and pg_xlog
disk 2 - pg_data without pg_xlog
or a better arrange sugge
Clodoaldo asked:
> I will build a cheap server and I'm in doubt about what would the the
> best for performance:
>
> 1 - everything in one lonely fast 10,000 rpm Raptor HD;
>
> 2 - two cheap 7,200 rpm 16MB cache HDs like this:
>
> disk 1 - system and pg_xlog
> disk 2 - pg_data without p
On Nov 24, 2007 5:09 AM, Clodoaldo <[EMAIL PROTECTED]> wrote:
> I will build a cheap server and I'm in doubt about what would the the
> best for performance:
>
> 1 - everything in one lonely fast 10,000 rpm Raptor HD;
>
> 2 - two cheap 7,200 rpm 16MB cache HDs like this:
>
> disk 1 - system and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/24/07 09:12, Scott Marlowe wrote:
> On Nov 24, 2007 5:09 AM, Clodoaldo <[EMAIL PROTECTED]> wrote:
>> I will build a cheap server and I'm in doubt about what would the the
>> best for performance:
>>
>> 1 - everything in one lonely fast 10,000 rpm
On Nov 24, 2007, at 8:17 AM, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/24/07 09:12, Scott Marlowe wrote:
On Nov 24, 2007 5:09 AM, Clodoaldo
<[EMAIL PROTECTED]> wrote:
I will build a cheap server and I'm in doubt about what would the
the
best for performance:
Hello every one.
im trying to make a Loop and i found in the manual this.
FOR IN LOOP
END LOOP
Can i use cursor instead of the Query in the loop?? ,
this es more legible than using the open/fetch/close of the cursor.
Regard Cesar Alvarez.
begin:vcard
fn:Cesar Alvarez
n:;Cesar Alvarez
titl
On 24/11/2007, Cesar Alvarez <[EMAIL PROTECTED]> wrote:
>
> Hello every one.
> im trying to make a Loop and i found in the manual this.
>
> FOR IN LOOP
>
> END LOOP
>
> Can i use cursor instead of the Query in the loop?? ,
> this es more legible than using the open/fetch/close of the
Thanks,
what will be the syntax for that type of for?
Pavel Stehule wrote:
On 24/11/2007, Cesar Alvarez <[EMAIL PROTECTED]> wrote:
Hello every one.
im trying to make a Loop and i found in the manual this.
FOR IN LOOP
END LOOP
Can i use cursor instead of the Query in the loop??
On 24/11/2007, Cesar Alvarez <[EMAIL PROTECTED]> wrote:
>
> Thanks,
> what will be the syntax for that type of for?
>
DECLARE
curs2 CURSOR FOR SELECT * FROM tenk1;
c1 integer;
c2 integer;
BEGIN
OPEN curs2;
FETCH curs2 INTO c1,c2;
WHILE found LOOP
...
FETCH curs2 INTO c1,c2;
Hi,
I'm currently setting up 2 new servers to act as a PgSQL cluster (8.2).
This basically consists in the reinstallation of the OS (64Bit).
Question:
I'd like to know if it is possible (and wise) to just keep the
/var/lib/postgres.. directories from the old 32Bit server to use on
the 64Bit
Douglas McNaught wrote:
> Nope, not possible--different architectures result in different data layouts.
>
> Dump & restore is the way to go.
>
Thanks,
I'll then dump/restore.
Laurent
---(end of broadcast)---
TIP 3: Have you checked our extensive
Hello,
I'm having serious problems with PostGreSQL and Windows Server 2003
Enterprise Edition. The PostgreSQL Server doesn't start if I set the shared
buffers higher than 1GB. All my programs can use only 3 GB of RAM and I have 8GB
of RAM.
When I monitor the processes I can see that PostGreSQL
Why the hell would you buy a 1U chassis in the first place when perfectly
good cheap 4U chassis exists that will take 8 or more drives?
1U motherboards are a pain, 1U power supplies are a pain and 1U space for
drives sucks.
Most tests I've seen these days show that there is very little actual
ben
14 matches
Mail list logo
