Hi
On 06/01/15 22:51, Marco Di Cesare wrote:
I am connecting to a Postgres instance using SSL and seeing fairly slow
connect times. I would expect there would be some overhead but it's more
than I anticipated. The connection is happening over a network. I am
using a wildcard SSL certificate on t
I am connecting to a Postgres instance using SSL and seeing fairly slow connect
times. I would expect there would be some overhead but it's more than I
anticipated. The connection is happening over a network. I am using a wildcard
SSL certificate on the server side only.
Using one of these JDBC
On Mon, Jun 1, 2015 at 7:20 AM, Merlin Moncure wrote:
> On Mon, Jun 1, 2015 at 12:38 AM, Ashik S L wrote:
>>> On 05/30/2015 09:46 AM, Ashik S L wrote:
We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
each row is of 60
"er.tejaspate...@gmail.com" wrote:
> If I have to find upcoming birthdays in current week and the
> current week fall into different months - how would you handle
> that?
If you don't need to cross from December into January, I find the
easiest is:
SELECT * FROM person
WHERE (EXTRACT(MONTH FR
Alex Adriaanse writes:
> I have several databases that have the same schema but different amounts of
> data in it (let's categorize these as Small, Medium, and Large). We have a
> mammoth query with 13 CTEs that are LEFT JOINed against a main table. This
> query takes <30 mins on the Small data
I have several databases that have the same schema but different amounts of
data in it (let's categorize these as Small, Medium, and Large). We have a
mammoth query with 13 CTEs that are LEFT JOINed against a main table. This
query takes <30 mins on the Small database, <2 hours to run on Large,
On Mon, Jun 1, 2015 at 12:38 AM, Ashik S L wrote:
>> On 05/30/2015 09:46 AM, Ashik S L wrote:
>>> We are using postgres SQL version 8.4.17..
>>> Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
>>> each row is of 60 bytes.Every time we insert 16380 bytes of data.
>>
>> Way bac
