On Fri, Aug 18, 2006 at 11:07:24AM -0400, Sumeet wrote:
>
> Will the full text search indexing help me achive a good speed in searching
> keywords???
I think this depends on how you use it.
> can someone plz ellaborate a little about ways we can enforce bounded
> searches?. I'm basically trying
On 8/15/06, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> I previously thought of doing the full text search indexing thing...but i> had a intution that the full text search thing is for fields which have very> large strings...but in my case the strings are not above 200 chars in
No, it's for d
On Tue, Aug 15, 2006 at 10:35:36AM -0400, Sumeet wrote:
>
> The reason for splitting up the dbs into differnet instances is that in case
> one of the postgres instances on the server
> goes down for some reason, it doesnt effect the other instances which are
> running on the same server. Even I do
On 8/15/06, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Tue, Aug 15, 2006 at 10:11:41AM -0400, Sumeet Ambre wrote:> >> The Design of the database is because our organization wants to split up> different datasets into different entities, and there might be a
> possibility that they'll run differen
On Tue, Aug 15, 2006 at 10:25:00AM -0300, Jorge Godoy wrote:
> I'd like to see some sort of data partitioning in PostgreSQL.
Sure, I think everybody would. I think it's among the more
interesting problems we have.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
On Tue, Aug 15, 2006 at 10:11:41AM -0400, Sumeet Ambre wrote:
> >
> The Design of the database is because our organization wants to split up
> different datasets into different entities, and there might be a
> possibility that they'll run different instances of postgres for each
> dataset.
I
Andrew Sullivan wrote:
On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote:
Hi All,
I have a database which consists of 20 million records and I've split up
the db into 6-7 dbs.
You can do this (as someone suggested with dblink), but I'm wondering
why the split? 20 million
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Tue, Aug 15, 2006 at 09:01:03AM -0300, Jorge Godoy wrote:
>> I can think that spreading processing requirements should be one. And
>> distributing load another one. Disk space can be solved with new disks and
>> tablespaces, but we can't yet distr
On Tue, Aug 15, 2006 at 09:01:03AM -0300, Jorge Godoy wrote:
> I can think that spreading processing requirements should be one. And
> distributing load another one. Disk space can be solved with new disks and
> tablespaces, but we can't yet distribute the load through several servers
> without p
Michael Fuhr <[EMAIL PROTECTED]> writes:
> And why multiple databases instead of multiple schemas within the
> same database? Or even all data in the same schema? Is there a
> reason for the segregation?
I can think that spreading processing requirements should be one. And
distributing load an
On Tue, Aug 15, 2006 at 06:36:24AM -0400, Andrew Sullivan wrote:
> On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote:
> > I have a database which consists of 20 million records and I've split up
> > the db into 6-7 dbs.
>
> You can do this (as someone suggested with dblink), but I'm w
On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote:
> Hi All,
>
> I have a database which consists of 20 million records and I've split up
> the db into 6-7 dbs.
You can do this (as someone suggested with dblink), but I'm wondering
why the split? 20 million records isn't very big.
A
I think using the contrib module 'dblink' (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/) can help you here.Thanks,
-- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 8/15/06, Sumeet Ambre <
[EMAIL PROTECTED]> wrote:Hi All,I have a database which consists of 20 million records an
Hi All,
I have a database which consists of 20 million records and I've split up
the db into 6-7 dbs. I have a base database which consists of
the ids with link all the databases. I'm performing search on this
single base table. After searching i get some ids which are ids in the other
database
14 matches
Mail list logo
