On Jan 26, 2018 6:02 AM, "Pavan Teja" wrote:
On Jan 26, 2018 3:00 AM, "Alvaro Herrera" wrote:
pavan95 wrote:
> Hi Álvaro Herrera,
>
> Please find the corresponding output:
OK, these settings look pretty normal, so they don't explain your
problem.
What is checkpoint_segments set to? And che
On Thu, Oct 26, 2017 at 02:45:15PM -0500, Justin Pryzby wrote:
> On Tue, Oct 24, 2017 at 04:15:59PM +0200, johannes graën wrote:
> > Hi Pavel, *,
> >
> > you were right with ANALYZing the DB first. However, even after doing
> > so, I frequently see Seq Scans where an index was used before. This
>
On Sunday, January 28, 2018, Nur Agus wrote:
>
> Is this a bug on postgres-9.4.4 ?
>
> We are considering upgrade to postgres-10 but since this is a very
> critical system, it takes a lot of test and approval :)
>
>
Upgrade to 9.4.15. Asking if 9.4.4 might have a bug is a question most
people h
On Mon, Jan 29, 2018 at 12:32:59AM +0700, Nur Agus wrote:
> The following query run in just 9 ms:
> "distrib_reports"."month" = 1 AND
> "distrib_reports"."year" = 2017 AND
> "distrib_reports"."state" = 'SUBMITTED' AND
> "distrib_report_groups"."distrib_report_group_type_id" =
> '559a5fdc-418d-
Hello,
I would like to report a strange behaviour on postgresql 9.4.4.
The following query run in just 9 ms:
SELECT SUM("distrib_report_items"."qty") AS sum_id
FROM
"distrib_report_items" INNER JOIN
"retailers" ON "retailers"."id" = "distrib_report_items"."retailer_id"
INNER JOIN
"distrib_rep
Hei
Sorry it's was a zero to much, it should 30-40 million weather observations pr
second.
Lars
Fra: Lars Aksel Opsahl
Sendt: 28. januar 2018 12:57
Til: Mariel Cherkassky; PostgreSQL mailing lists
Emne: SV: copy csv into partitioned table with unique index
Hi
We had the same problems with performance when testing with more than 100
billion weather observations. We now have a solution where we can push between
300 and 400 million weather observations pr. Second into the database.
We download date from NetCDF files. The date are joined based on t
Did you try to transform your temp table into a table partition using the
ALTER TABLE ATTACH syntax
https://www.postgresql.org/docs/10/static/ddl-partitioning.html
Regards
PAscal
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
Hi,
I configured a master table that is called "year_2018" :
create table year_2018(a int,b int c date);
The master table has a unique constraint on those 3 columns so that I wont
have any duplicated rows. Moreover, I configured a before insert trigger on
that table that creates a child table for
