* Disk speed
4 drives... 7200 RPM... as big as you can get. Get 8 Meg cache drives so
you have a 3 year warranty.
* Hardware RAID
3Ware IDE controller (or SATA) running RAID 10
* Memory
2 gig
* Processor speed
1800+
* Processor type
Athlon MP
* Multiple processors
2
We are able to run a
I need to update that. 7.4 will use many more shared buffers by
default.
Yes, they are very small because we want to start even on small machines.
---
Knut P. Lehre wrote:
> The doc "PostgreSQL Hardware Performance Tuning"
Tom Lane writes:
> (Including PLs in the standard distro strikes me as a good idea, BTW.
> They usually need maintenance along with the core backend code.)
We could also say that keeping some PLs outside the core would keep us
more honest in keeping the interfaces stable. The only maintenance th
Just a quick note to everyone that v7.4 is now official in Beta Freeze,
with the first Bundle available for download, testing and bug reports ...
The Bundle is available on all FTP mirrors (in both .gz and .bz2 format)
under:
/pub/source/v7.4
We encourage everyone that is able to downlo
On Tuesday 05 August 2003 03:31 am, Jean-Christian Imbeault wrote:
> shreedhar wrote:
> > Is it necessary to uninstall previous version of PHP in my system.
>
> No，but a new recompile will probably over-write the version you have now.
>
> > Which is the better compatible ve
I have a table (lets say a,text b,text) and I want to insert the data jim,jimmy and
trav,travis can I do this with 1 insert into statement instead of 2?
Travis
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an approp
On Tue, 5 Aug 2003, Peter Eisentraut wrote:
> Tom Lane writes:
>
> > (Including PLs in the standard distro strikes me as a good idea, BTW.
> > They usually need maintenance along with the core backend code.)
>
> We could also say that keeping some PLs outside the core would keep us
> more honest
A nice addition to the dump commands would be something like:
-scope( schema( schema_s), tables( table_1), dbases_name objects( tables, indexes, constraints, types, functions, triggers, data, etc) )
if it could be completely hierarchial, then any set of objects desired could be extracted.
Step
in looking over the section of the users manual on indices, i see that
R-Tree indices are recommended for <<, but this advice is clearly tied to
the geometric interpretation of << ("to the left of") rather than the
network interpretation ("is contained in").
what type of index is recommended when
I second that.
I have discussed adding partitioning tables almost a year ago...
No need to partition a functional index or anything like that.
Just partition on a specific field.
Ron Johnson wrote:
>[...]
> Partitioning "should" be put on the TODO list soon after tablespaces
> (or DBA-defined dir
Below is the EXPLAIN ANALYZE output of a typical current query.
I have just begun looking at tsearch2 to index the header and body
fields.
I have also been using 'atop' to see I/O stats on the disk, i am now
pretty sure thats where the current bottleneck is. As soon as a query
is launched the
Hi
did you configure php for PostgreSQL support
./configure --with-pgsql
Regards
Conni
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
12 matches
Mail list logo
