[ADMIN] How to install plperl on Windows?

Hi, Hope someone can help me with this. Installed postgresql-8.0-beta2-dev3.msi, then installed Perl 5.8: activeperl5.8.4. When issuing a createlang plperl it errs with: createlang: Language installation failed: ERROR could not load library "C:\Program Files\PostgreSQL\8.0-beta2-dev3\lib\plperl.

[ADMIN] best way to revert back to 7.3.3?

Need a hand. Was running 7.3.3 with several databases on a windows/cygwin platform. Recently downloaded/installed 7.4.5-1 from cygwin.com without first dumping my 7.3.3 databases needed for the upgrade. Have to go back to 7.3.3 and dump the databases. Tried installing 7.3.3 from source, conf

Re: [ADMIN] analytics

Thanks to all who replied. I guess I realize odbc may work for most of the products as long as the analytics tool works with RDBMS. We'll be explore the Mondrian option as well. Regards, Ben Kim Database Developer/Systems Administrator College of Education Texas A&M University On Wed, 22 S

Re: [ADMIN] Vacuum full - disk space eaten by WAL logfiles

"Thomas Madsen" <[EMAIL PROTECTED]> writes: > I raised it to 3,000,000 and tried a "VACUUM FULL" on the table. Out > popped an error when it reached the toast table index: "Number of tuples > (xxx) not same at number in heap (XXX), recreate index". The numbers > (XXX) differed by just 2. It then st

[ADMIN] Help determining values for max_fsm_pages, max_fsm_relations

I need some help tuning my free space map. I have about 275 GB of db's spread across 3 DB servers. Unfortunetly, due to design and bandwidth issues, I am not able to vacuum during business hours, and can only vacuum at night. I am trying to get my free space map big enough to hold all of the pag

Re: [ADMIN] tsearch2 poor performance

Kris Kiger wrote: > search_test=# explain analyze SELECT count(q) FROM product, > to_tsquery('oil') AS q WHERE vector @@ q; > QUERY PLAN > --

[ADMIN] Vacuum full - disk space eaten by WAL logfiles

Title: Message Hi!   I ran in to a serious problem with a server running Postgresql 7.2.1. I know that an upgrade would be in its place, but this is not an option at the moment.   The problem started with the server running out of space (toast table galore) due to a too low max_fsm_pages nu

[ADMIN] index for or relation

Hi All ! Maybe that a basic question ,sorry. I have to 2 tables : Column |Type | Modifiers +-+--- yaadid | numeric(19,0) | populationtype | character varying(50) | popula