> What directives do I have to configure when compiling Postgresql 7.1
(on
> Solaris and Debian/Gnu Linux) to remove the 8k record size limit?
Since version 7.1 there is no limit in the row size. OK, the row size
has a limit of 2 GB I think.
---(end of broadcast)---
>On Thu, May 31, 2001 at 10:37:26AM +0200, David Lizano wrote:
> > You can't do it with Postgres. To do it, Postgres must implement
> > "tablespaces" to spread the database in different localizations (who
> can be
> > different physical localizations, o
You can't do it with Postgres. To do it, Postgres must implement
"tablespaces" to spread the database in different localizations (who can be
different physical localizations, of course). Then a table can be assigned
to a tablespace.
If the RDBMS implements partitions also, you can distribute a
Ok,
I have installed version 7.0.3 and 7.1 from RPM in Red Hat 6.2 (both in
the same system), and I don't have had any trouble with the first one, but
all this with the second one.
>David Lizano wrote:
> > I have installed PostgreSQL v7.1 in RedHat from RPM's and I have
/etc/rc.d/init.d/postgresql /etc/rc.d/rc4.d/S50postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc5.d/S50postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc0.d/K25postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc1.d/K25postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d
>For large tables that require a 24/7 uptime and see around 6-10 million
>changes a day, how do I run VACUM without taking the database/table down.
>Considering moving from MySQL, but can't quite understand how to run
>PostgreSQL in a production enviroment properly.
a) Using replication, you ca
LECT * FROM painters WHERE artist_name ~* 'Dali');
You obtain
(SELECT * FROM painters WHERE artist_name ~* 'D[Aaáä]l[Iiíï]');
generating a new complete regular expression for the SQL language.
It should be valid for Dali, Dáli, Dalí, Dálí, and others.
~~~
can close all the opened resources like files and pipes.
~~~~~~
David Lizano - Director área técnica
correo-e: [EMAIL PROTECTED]
I Z A N E T - Servicios integrales de internet.
web: http://www.izanet.com/
Dirección: C/ Checa, 57-59, 3º D - 50.007 Zaragoza (Esp
