Thanks. Here is what exactly I am doing:
I am working on distributes spatial databases. I am trying to speed up join:
1. I am creating an external r*-tree index on the largest table
2. Then distributing the leaves of the r* tree on different nodes of a cluster(Each node has its own instance of
[reformatted for sanity]
> On Mon, Jun 20, 2005 at 11:09:36PM -0700, gayatri ganpaa wrote:
> > How do I change the page size in postgresql? I have the postgresql-7.4.3
> > version.
> > I am trying to create an r*-tree index on a spatial table with
> > around 100,000 rows. I just want to check i
pg_dumpall
Change something in one of the header files (which is docummented
somewhere...)
Recompile, install, initdb
restore from backup
Of course the backup/restore are optional if you don't care about your
data...
On Mon, Jun 20, 2005 at 11:09:36PM -0700, gayatri ganpaa wrote:
> Hi,
> How do I
Anjan,
I would be very interested in this feature as well. However, my
understanding is that you must keep the connection open AND your
application must retain the SAME connection between database
interactions.
The only way that I have done this is by creating a Session ID
column to your tabl
sandhya wrote:
Hi,
I am new to this postgresql database.I can able to create
databases,tables etc...using PQexecwhich is a C-library.Is there any
way to do it using C++ library i.e.,by using libpqxx?
Precisely.
See http://pqxx.tk/ for the project website and
http://gborg.postgresql
Hi,
I am new to this postgresql database.I
can able to create databases,tables etc...using PQexecwhich is a
C-library.Is there any way to do it using C++ library i.e.,by using
libpqxx?
If anybody knows pls help me how to proceed
further.
Thanks &Regards,
Sandhya R
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lim Swee Nyin wrote:
| hi There,
|
| When I was fine tuning my already running application, all of the
| sudden, I couldn't perform any save/edit operation on my database, with
| the error such as:
|
| ERROR: could not extend relation 4273000/17231/92
