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
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
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
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
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;
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:
>
> 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
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 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:
-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 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
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
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
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
14 matches
Mail list logo