Hi,
I've read this:
http://wiki.postgresql.org/wiki/Prioritizing_databases_by_separating_into_multiple_clusters
But it doesn't really say anything about memory.
If i can fit an extra cluster into it's shared buffer, it should have fast
reads, right?
Even if i don't have seperate spindles and the
On Tue, Jun 26, 2012 at 8:36 AM, Merlin Moncure wrote:
> On Thu, Jun 21, 2012 at 3:07 PM, Andy Halsall
> wrote:
>> I have two tables node and relationship. Each relationship record connects
>> two nodes and has an application keys (unfortunately named) that can be used
>> by the application to l
On Thu, Jun 21, 2012 at 3:07 PM, Andy Halsall wrote:
> I have two tables node and relationship. Each relationship record connects
> two nodes and has an application keys (unfortunately named) that can be used
> by the application to look-up a relationship and get from one node to the
> other.
>
>
2012/6/26 Maxim Boguk :
>
>
> On Tue, Jun 26, 2012 at 6:04 PM, Pavel Stehule
> wrote:
>>
>> 2012/6/26 Marc Mamin :
>> >
>> >>> On 22/06/12 09:02, Maxim Boguk wrote:
>> >
>> >>> May be I completely wrong but I always assumed that the access speed
>> >>> to the array element in PostgreSQL should be
2012/6/26 Marc Mamin :
>
>
>> -Original Message-
>> From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
>>
>> 2012/6/26 Marc Mamin :
>> >
>> >>> On 22/06/12 09:02, Maxim Boguk wrote:
>> >
>> >>> May be I completely wrong but I always assumed that the access
>> speed to the array element in
> -Original Message-
> From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
>
> 2012/6/26 Marc Mamin :
> >
> >>> On 22/06/12 09:02, Maxim Boguk wrote:
> >
> >>> May be I completely wrong but I always assumed that the access
> speed to the array element in PostgreSQL should be close to co
2012/6/26 Marc Mamin :
>
>>> On 22/06/12 09:02, Maxim Boguk wrote:
>
>>> May be I completely wrong but I always assumed that the access speed to the
>>> array element in PostgreSQL should be close to constant time.
>>> But in tests I found that access speed degrade as O(N) of array size.
>
>>> Is
>> On 22/06/12 09:02, Maxim Boguk wrote:
>> May be I completely wrong but I always assumed that the access speed to the
>> array element in PostgreSQL should be close to constant time.
>> But in tests I found that access speed degrade as O(N) of array size.
>> Is that behaviour is correct?
>
