Hi everybody,
I'm fairly new to PostgreSQL and I have a problem with
a query:
SELECT * FROM "LockerEvents" LIMIT 1 OFFSET
1099
The table LockerEvents has 11 Mlillions records on it
and this query takes about 60 seconds to complete.
Moreover, even after making for each column in the
table
Hi everybody,
I know that this group deals with performance but is the only one on which I'm
subscribed, so my apologize in advance for the question.
I want to allow everybody in the world, all IP's, to connect to my server. How
do I accomplish that? Definitely, it's not a good solution to ente
Hi guys,
A nub question here since I could not figure it out on my own:
I'm using Hamachi to connect different sites into a VPN and their address
always starts with 5.*.*.* - the problem I'm facing is that I cannot make the
access restricted to that particular range only.
Currently I got :
host a
Ah, that did the trick, thank you Kevin,
Danny
From: Kevin Martyn
To: idc danny
Cc: "pgsql-performance@postgresql.org"
Sent: Wednesday, December 14, 2011 3:14 PM
Subject: Re: [PERFORM] copy vs. C function
try
host all all 5.0.0.0/8 md5
On W
Hi all,
I got 2 complementary functions, which will do opposite things.
1 - CombineStrings(stringarray character varying[]) RETURNS character varying
This one will take as parameter an array of strings and will return a string
with some formatted information inside
2- SplitString2Array(stringtos
Hi Stefan
1 - If you have a fixed data that does not change a lot, like I assume is your
fixed 'map' try implementing in your app the hashtrie method. This looks as
better approach as your query is quite fast. Usually I am starting to query my
queries (or the query planner) when they start to ta
