"James Gunzelman" <[EMAIL PROTECTED]> writes:
>Will I have to dump and reload all my databases when migrating from
>7.4.2 to 8.0?
Yes.
-Doug
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Kevin Barnard <[EMAIL PROTECTED]> writes:
>Actually you are both are right and wrong. The XRaid uses
>FibreChannel to communicate to the host machine(s). The Raid
>controller is a FibreChannel controller. After that there is a
>FibreChannel to UltraATA conversion for each drive,
Josh Berkus <[EMAIL PROTECTED]> writes:
> Robert,
>
>> Just curious if folks have ever used this for a postgresql server and if
>> they used it with OSX/BSD/Linux. Even if you haven't used it, if you
>> know of something comparable I'd be interested. TIA
>
\> Last I checked Apple was still shippi
Paul Langard <[EMAIL PROTECTED]> writes:
> Having trouble with one table (see time to count records below!).
>
> Fairly new to postgres so any help much appreciated.
>
> It only contains 9,106 records - as you can see from:
>
>
> select count(id) from project
>
> count
> 9106
> 1 row(s)
> Total ru
Chris Cheston <[EMAIL PROTECTED]> writes:
> shared_buffers = 40 # min 16, at least max_connections*2, 8KB each
This is ridiculously low for any kind of production server. Try
something like 5000-1 for a start.
-Doug
---(end of broadcast)
"Domenico Sgarbossa" <[EMAIL PROTECTED]> writes:
> Thanks for your advice!
>
> It seems that the cached memory isn't released by the system... so the
> system begin to swap to disk!
If you really think this is true, there should be a process that is
holding on to the memory. Use 'ps' to find tha
Paul Ganainm <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] says...
>
>
>> XFS.. hands down.
>
>
> Off topic question here, but I'm a bit at a loss to understand exactly
> what sgi are doing.
>
>
> I thought that they were removing IRIX and going with Linux as the OS to
> their high end graphic
"D. Dante Lorenso" <[EMAIL PROTECTED]> writes:
> I'm running PostgreSQL 7.4 on a quad Xeon attached to a
> beefy disk array. However, I am begining to wonder if this is
> a waste of CPU power.
>
> I think I read somewhere that PostgreSQL is NOT multi-threaded.
> But, will it be able to take advan
Paul Tuckfield <[EMAIL PROTECTED]> writes:
> In the case of select count(*), one optimization is to do a scan of the
> primary key, not the table itself, if the table has a primary key. In a
> certain commercial, lesser database, this is called an "index fast full
> scan". It would be important
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> It appears that the optimizer only uses indexes for = clause?
>
> The optimizer will used indexes for LIKE clauses, so long as the
> clause is a prefix search, eg:
>
> SELECT * FROM test WHERE a LIKE 'prf%';
Doesn't this still depend on your
10 matches
Mail list logo
