Am 25.10.20 um 10:26 schrieb Nikolai Lusan:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Hi,
I was wondering where I can see open feature requests. One I would like
to see is multi-master replication ... I did find a 2016 request that
was marked as "planned", but to the best of my knowled
Am 29.10.20 um 20:12 schrieb Atul Kumar:
hi,
I am trying to configure streaming replication on windows server.
i have postgres version 10
after successful installation of postgres, I create a archive
directory "C:\Program Files\PostgreSQL\10\archive_files" and here in
archive_flies, I need
On 4 November 2020 11:24:03 CET, Shani Israeli
wrote:
>Hi all,
>
>We are running PostgreSQL v9.5.19 over Windows Server 2012 R2, 16GB
>RAM.
>Lately, postgres started to crash (happened already 3 times ~once a
>month)
>and before its crashes I found this message in Event Log:
>
>PANIC: could not
Am 12.11.20 um 18:34 schrieb Michael Lewis:
MERGE command is implemented for this use case in some DBMS, but not
Postgres (yet?).
MERGE is available in 2ndqPostgres, but that's not open source (it's
available for 2ndQ-customers on request).
Regards, Andreas
--
2ndQuadrant, an EDB compan
Am 19.11.20 um 15:05 schrieb Asya Nevra Buyuksoy:
connection to database failed: could not connect to server: Connection
refused (0x274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 50432?
could not connect to server: Connection refuse
Am 26.12.20 um 17:20 schrieb venkata786 k:
Hi Ganesh,
BDR supports postgres 12 & 13 versions ??
I think we have BDR compatible for 9.4 postgres.
Could you plz confirm.
That's true. PG 9.4 is out of support.
Regards, Andreas
--
2ndQuadrant, an EDB company
www.2ndQuadrant.com / www.enterp
On 3 January 2021 13:59:31 CET, Thomas Flatley wrote:
>Hello, I've checked the docs but cant seem to find if there is a max #
>of tablespaces allowed - I've come across a 9.5 env with 1600
>tablespaces - they want to double that
why on earth do you think you will need so many tablespaces? They h
On 3 March 2022 08:46:45 CET, pgdba pgdba wrote:
>Hi ,
>
>I have a problem from pg_wal. I am using postgresql version 11 and taking
>backup and writing archive_command in postgresql.conf but did not archive wal
>and my disk ise full from pg_wal. I research why is my wal is full and dont
>found
umn on the table, and using that
instead.
100% ACK.
Andreas
--
Andreas Kretschmer
Technical Account Manager (TAM)
www.enterprisedb.com
Am 06.07.22 um 07:54 schrieb Andreas Kretschmer:
Am 06.07.22 um 07:44 schrieb Christophe Pettus:
On Jul 5, 2022, at 22:35, Matthias Apitz wrote:
Internally, in the DB layer, the read_where() builds the row list
matching
the WHERE clause as a SCROLLED CURSOR of
SELECT ctid, * FROM
pg_stat_user_tables. There can you find how often the table was queried
in the past. Take the data, wait some time, take it again and compare.
Regards, Andreas
--
Andreas Kretschmer
Technical Account Manager (TAM)
www.enterprisedb.com
at those commands
>>> would actually do.
>> Hmph. I'm surprised to realize that those commands don't produce
>> trace output comparable to DROP CASCADE. If they did, this need
>> would be met by the traditional hack of "BEGIN; DROP ...; ROLLBACK".
>
>So... you'll add it to v16 :D
>
+1 as feature request
--
Andreas Kretschmer, EDB
On 22 December 2022 04:00:57 CET, Yi Sun wrote:
>Hello guys,
>
>We are planning the server disk space, pg_wal directory max size is wal
>file size*wal_keep_segments? or is it also decided by other parameters
>please? We tried to search for this, but could not find the answer
>
>For example our pos
On 22 December 2022 04:00:57 CET, Yi Sun wrote:
>Hello guys,
>
>We are planning the server disk space, pg_wal directory max size is wal
>file size*wal_keep_segments? or is it also decided by other parameters
>please? We tried to search for this, but could not find the answer
>
>For example our pos
On 23 October 2018 14:24:28 WEST, "Daniel Fink (PDF)"
wrote:
>Hi all,
>
>
>
>I already have a running cluster of BDR nodes.
>
>Now we want to add an additional database on the same hosts.
>
>
>
>Can I just create a new database and then create/join nodes as in this
>description:
>
>http://bdr-pro
On 26 October 2018 13:22:19 WEST, Mike Martin wrote:
>Is this possible?
>I have a script which imports csvlogs into a table, and it would be
>useful
>to truncate the log files after import
>
You can use an untrusted language (pl/perlu, pl/sh, ...).
Regards, Andreas
--
2ndQuadrant - The Post
Am 03.11.2018 um 23:47 schrieb Charles Martin:
When I do a pg_dump using PG 9.6, I got this:
pg_dump: Dumping the contents of table "docfile" failed:
PQgetCopyData() failed.
pg_dump: Error message from server: server closed the connection
unexpectedly
This probably means the server term
Am 04.11.2018 um 17:38 schrieb Charles Martin:
Andreas said:
>which exact minor version please?
PostgreSQL 9.6.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-23), 64-bit
okay, i asked to just rule out a stale version. 9.6.7, for instance,
contains som
On 7 November 2018 06:13:20 CET, Elson Vaz wrote:
>Hello people,
>
>
>I need a lot of help,
>
>Accidentally I deleted all the files from the database,
> ...
>I have also back up the complete database directory for a month.
Install the latest backup. Consider a better backup procedure for the fut
Am 09.11.2018 um 13:58 schrieb Daniel Westermann:
Is that because of some sort of caching?
no, but vacuum updated the visibility map in the meantime.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Am 13.11.2018 um 17:42 schrieb Олег Самойлов:
insert into gender (gender) select case when random<0.50 then 'female'
when random<0.99 then 'male' else 'other' end from (select random() as
random, generate_series(1,:table_size)) as subselect;
is that really your intended data distibution? 99
Am 13.11.2018 um 19:12 schrieb Ron:
On 11/13/2018 12:07 PM, Andreas Kretschmer wrote:
Am 13.11.2018 um 17:42 schrieb Олег Самойлов:
insert into gender (gender) select case when random<0.50 then
'female' when random<0.99 then 'male' else 'other'
Am 15.11.2018 um 08:54 schrieb Sathish Kumar:
We would like to migrate our Postgresql VM instance on Google Cloud
Platform to Google Cloud SQL with a minimal downtime. As I checked, we
have to export and import the SQL file and our database size is large
and cannot afford longer downtime.
Am 15.11.2018 um 16:09 schrieb Mark Moellering:
I can see how, for only a few (hundreds to thousands) of users, the
latter might make more sense but if I need to scale up to millions, I
might not want all of those connections open.
consider a connection-pooler like phbouncer.
Regards, And
Am 15.11.2018 um 16:14 schrieb Andreas Kretschmer:
Am 15.11.2018 um 16:09 schrieb Mark Moellering:
I can see how, for only a few (hundreds to thousands) of users, the
latter might make more sense but if I need to scale up to millions, I
might not want all of those connections open
Am 28.11.2018 um 16:16 schrieb pavan95:
The objects in the database "abc" are moved to custom schema named "xyz".
Then we're facing this error "2018-11-28 10:40:01,906 9672 CRITICAL ?
odoo.service.server: Failed to initialize database `abc`" . In detail it is
throwing the error "relation ir_%%
Am 10.12.18 um 11:15 schrieb Olga Vingurt:
After playing with the dump and importing schema first and data next
without the triggers we indeed see that data is missing in the table
i.e. dump is not consistent.
We don't stop the application which uses database during the dump but
according to
Am 04.01.19 um 17:53 schrieb Rich Shepard:
I have a projects table that includes these two columns:
start_date date DEFAULT CURRENT_DATE,
end_date date
CONSTRAINT valid_start_date
CHECK (start_date <= end_date),
1. Do I need a DEFAULT value for the end_date?
no, you can use NULL,
Am 04.01.19 um 18:32 schrieb Rich Shepard:
other solution for such 2 fields: you can use DATERANGE, only one field.
Only if all projects have a known end_date; some don't.
that's not a problem:
test=*# create table projects(duration daterange default
daterange(current_date,null) check(
Am 15.01.19 um 20:42 schrieb Ramamoorthi, Meenakshi:
Dear folks:
1)Can someone please send me a link of all companies using PostgreSQL ?
you can find some case studies here:
https://www.2ndquadrant.com/en/about/case-studies/
We have a lot more customers, but i can't list them here, due
Am 25.01.19 um 06:10 schrieb Jeremy Finzel:
The problem is that the version for BDR 1.0.7, which has an
implementation for postgres 9.4, will be on end of live at the end
of this year. Unfortunately the paid solution is out of our
budget, so we currently have two options: find
Am 25.01.19 um 10:10 schrieb Andreas Joseph Krogh:
To my surprise I'm unable to find downloadable BDR3. I thought it was
an open-source extention to vanilla-pg-11, isn't that the case anymore?
yeah, you have to sign a support contract. It works as a extension to
vanilla-pg-11, but it's not
Am 04.02.19 um 11:10 schrieb A H S Phanindra:
Hi,
I am using Jboss EAP 6.1 version. For Database i am using the
postgres 9.3 version. Can i upgrade to postgres 9.6 without any issue.
should work, but you should test it.
I am also considering to implement BDR 2.0, please let me know ho
On 12 February 2019 17:20:09 CET, Vikas Sharma wrote:
>Hello All,
>
>I have a 4 node PostgreSQL 9.6 cluster with streaming replication. we
>encounter today the Out of Memory Error on the Master which resulted
>in
>All postres processes restarted and cluster recovered itself. Please
>let
>me kno
Am 21.02.19 um 08:17 schrieb Julie Nishimura:
Does anyone use this solution? any recommenations?
Thanks!
sure, many of our customers. why not?
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
On 26 February 2019 10:41:19 CET, Sonam Sharma wrote:
>Hi,
>
>Can we do master to master replication in Postgres.
>
Not in core, but with BDR.
Andreas
--
2ndQuadrant - The PostgreSQL Support Company
Am 05.03.19 um 17:51 schrieb Vijaykumar Jain:
Thanks Tom.
I mean if the instance is a test instance,
probably analysis_name_date_key can be dropped and the query can be
run again so as to check if it still returns the correct rows.
or create an index in parallel with the same col as
analysis
On 5 March 2019 18:54:33 CET, Tom Lane wrote:
>Andreas Kretschmer writes:
>> the other thing is, it would be nice to to know why the index is
>corrupt.
>
>Given that (a) this was triggered by a server migration and (b)
>the leading column of the index looks like it
Am 05.03.19 um 19:09 schrieb Matthew Pounsett:
On Tue, 5 Mar 2019 at 12:54, Tom Lane <mailto:t...@sss.pgh.pa.us>> wrote:
Andreas Kretschmer mailto:andr...@a-kretschmer.de>> writes:
> the other thing is, it would be nice to to know why the index is
corrupt.
Am 05.03.19 um 19:41 schrieb Casey Deccio:
On Mar 5, 2019, at 10:37 AM, Andreas Kretschmer
mailto:andr...@a-kretschmer.de>> wrote:
no, but you can set enable_indexscan to off and maybe also
enable_bitmapscan to off to force the planner to choose a seq-scan.
I'm sure in th
Am 06.03.19 um 00:34 schrieb Julie Nishimura:
Hello there,
Is it possible for a test app to connect to the standby dB of an
active-Standby dB pair?
that's possible, but ...
While both continue to be connected and replicating? What if it’s
needed to write tmp tables that are later dropped
Am 06.03.19 um 01:26 schrieb Mark Fletcher:
Hi All,
On a 9.6 streaming replica, we do table scans for stats and other
things. During these scans, the replication is paused (the
'recovering' postgres process has 'waiting' appended to it). We're not
using transactions with these scans. Is th
On 6 March 2019 06:26:45 CET, Julie Nishimura wrote:
>Thank you. Are you going to have any presentations on Postgresql
>conference in NYC soon?
>
>
>From: Andreas Kretschmer
>Sent: Tuesday, March 5, 2019 9:16 PM
>To: pgsql-general@lists.postgr
Am 06.03.19 um 06:41 schrieb Mark Fletcher:
Thank you for responding to my email.
On Tue, Mar 5, 2019 at 9:20 PM Andreas Kretschmer
mailto:andr...@a-kretschmer.de>> wrote:
have you set ```max_standby_streaming_delay``? The default is 30
seconds, which means that this will
Am 09.03.19 um 02:05 schrieb Joseph Dunleavy:
I am building a multi-tenant deployment with multiple database - 1
tenant per database.
I would like to be able to dedicate specific temp tablespace to
a specific database or user/schemas.
I understand how to define temp_tablespace in postgr
Am 11.03.19 um 06:44 schrieb Nanda Kumar:
Hello Tem,
Can you please help on the below issues . The below Error occurred when I run
the select statement for the huge data volume.
Error Details :
Ran out of memory retrieving query results.
you should provide more details, for instance
Am 15.03.19 um 18:55 schrieb basti:
Hello,
I want to insert data into table only if condition is true.
For example:
INSERT into mytable (domainid, hostname, txtdata)
VALUES (100,'_acme.challenge.example', 'somedata');
The insert should only be done if Hostname like %_acme.challenge%.
Am 28.03.19 um 09:20 schrieb Sridhar N Bamandlapally:
Hi PG-General and Pgsql-Admin
Can we achieve CASE INSENSITIVE in PostgreSQL?
test=# create extension citext;
CREATE EXTENSION
test=*# create table emp (eid int, ename citext);
CREATE TABLE
test=*# insert into emp values (1, 'aaa');
INSER
Am 28.03.19 um 09:33 schrieb Sameer Kumar:
test=*# select * from emp where ename = 'aaa';
eid | ename
-+---
1 | aaa
2 | AAA
(2 rows)
Ummm... Will it use an index (a BTree index)?
test=# explain select * from emp where ename = 'aaa';
On 29 March 2019 05:13:31 CET, github kran wrote:
>Hello Team,
>
>We are using PostgreSQL Version 9.6 and planning to archive our
>partition
>tables containing about 300 - 500 million rows . We have around ~ 50
>partition tables to be archived to a new
>cold path PostgreSQL database , version 10.6
On 1 April 2019 08:09:37 CEST, Sathish Kumar wrote:
>Hi Team,
>
>We have a requirement to copy a table from one database server to
>another
>database server. We are looking for a solution to achieve this with
>lesser
>downtime on Prod. Can you help us with this?
>
>Table Size: 160GB
>Postgresql Se
Am 13.04.19 um 11:22 schrieb Nithin Johnson:
We are seeing this intermittent problem after we upgrade (using
pg_upgrade) from postgres 9.3.12 to 9.6.12
Querying few of the rows in the table using a TEXT field is failing.
sounds like a corrupt index, can you show us the complete error m
Am 15.04.19 um 12:41 schrieb Francisco Olarte:
On Mon, Apr 15, 2019 at 4:11 AM Takahashi, Ryohei
wrote:
If application executes COMMIT statement and COMMIT failes because of
PostgreSQL crash,
it is unknown whether the transaction is really committed.
Therefore, I think application should ch
Am 18.04.19 um 08:52 schrieb rihad:
Hi. Say there are 2 indexes:
"foo_index" btree (foo_id)
"multi_index" btree (foo_id, approved, expires_at)
foo_id is an integer. Some queries involve all three columns in their
WHERE clauses, some involve only foo_id.
Would it be ok from general
Am 05.05.19 um 18:47 schrieb Sathish Kumar:
Is there a way to speed up the importing process by tweaking
Postgresql config like maintenance_workmem, work_mem, shared_buffers etc.,
sure, take the dump in custom-format and use pg_restore with -j
. You can increase maintenance_work_mem maybe t
Am 05.05.19 um 19:26 schrieb Ron:
On 5/5/19 12:20 PM, Andreas Kretschmer wrote:
Am 05.05.19 um 18:47 schrieb Sathish Kumar:
Is there a way to speed up the importing process by tweaking
Postgresql config like maintenance_workmem, work_mem, shared_buffers
etc.,
sure, take the dump in
Am 16.05.19 um 11:57 schrieb Winanjaya Amijoyo:
Hi All,
I have records as below that I inserted using exclusion gist constraint
user_id start_date end_date pid
001 2019-01-01 2019-02-10 1
001 2019-02-01 2019-03-12 2
001 2019-03-0
On 28 May 2019 20:20:10 CEST, Julie Nishimura wrote:
>What is the impact of fsm_relatiosn being maxed out?
https://www.postgresql.org/docs/8.2/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM
Please no top-posting with fullquote.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Supp
>
>Are CTEs still optimization fences?
>https://www.2ndquadrant.com/en/blog/postgresql-ctes-are-optimization-fences/
Yes, but not in 12.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company
Am 31.05.19 um 14:06 schrieb Saurabh Agrawal:
Which query are you trying to run?
you can show us also the EXPLAIN - Output.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Am 10.06.19 um 18:35 schrieb Hilbert, Karin:
We did this as a precaution against disk failure. If we lose one, we
would still have the other two to recover from.
Is that really necessary anymore, with having a repmgr cluster?
Repmgr is for HA, not for Backup/Recovery.
Regards, Andrea
On 11 June 2019 19:45:27 CEST, Igal Sapir wrote:
>I'm doing a presentation about Postgres to SQL Server users this
>weekend,
>and I want to showcase some of the big names that use Postgres, e.g.
>MasterCard, Government agencies, Banks, etc.
>
>There used to be a Wiki page of Featured Users but tha
Am 12.06.19 um 14:50 schrieb Rahul Chordiya:
postgres=#
postgres=# select subscription_name, status FROM
pglogical.show_subscription_status();
subscription_name | status
---+
(0 rows)
postgres=# select pglogical.create_subscription(subscription_name :=
'subscriptio
Consider table partitioning. You can detach, save and delete partitions, and
you can restore and attach partitions.
On 8 May 2023 12:24:06 CEST, Age Apache wrote:
>I am designing a database for a web application. In the near future I will
>require past data for Audit, Security and Analysis purpo
It is in epas15, but for the whole cluster. Different keys for each database is
not possible, how should it works for instance the wal - stream?
On 18 May 2023 00:35:39 CEST, Tony Xu wrote:
>Hi There,
>
>The FAQ (copied below) mentioned that native transparent data encryption
>might be included
On 9 June 2023 12:38:40 CEST, Mohsin Kazmi wrote:
>Hello Everyone,
>
>I have been working on PostgreSQL databases for the last three years and I
>have also migrate databases from Oracle to PostgreSQL as well. I configured
>PostgreSQL for logical replication as well.
>
>Now in order to deploy Po
On 22 June 2023 07:09:26 CEST, KK CHN wrote:
>*Description of System: *
>1. We are running a Postgres Server (version 12, on CentOS 6) for an
>emergency call attending and vehicle tracking system fitted with mobile
>devices for vehicles with navigation apps for emergency service.
>
>2. vehic
On 14 August 2023 11:59:26 CEST, Sai Teja
wrote:
>Hi Team,
>
>We are trying to fetch the one row of data (bytea data) for one table in
>But getting the error stating that "Invalid Memory alloc request size
>1236252631"
>
>The row which we were trying to fetch have one bytea column which is mor
On 22 August 2023 06:52:10 CEST, Ron wrote:
>On 8/21/23 18:49, Bruce Momjian wrote:
>> On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote:
>>> Hi there,
>>>
>>> It is mentioned here https://www.postgresql.org/about/press/faq/#:~:text=
>>> Q%3A%20What%20features%20will%20PostgreSQL%2
online, but primary no waits
confirmation from replica if replica is not connected?
yes, with 3 or more sync. standbys.
Andreas
--
Andreas Kretschmer
Technical Account Manager (TAM)
www.enterprisedb.com
?
please also check
https://www.cybertec-postgresql.com/en/postgresql-understanding-deadlocks/
Andreas
--
Andreas Kretschmer
Technical Account Manager (TAM)
www.enterprisedb.com
details.
2023-09-30 16:50:50.951 CEST [18117] CONTEXT: while locking tuple (38,57) in relation
"d03geb"
2023-09-30 16:50:50.951 CEST [18117] STATEMENT: fetch hc_d03geb
have you checked the server log?
See server log for query details.
Regards, Andreas
--
Andreas Kretschmer
Technic
23 14:18:28.742152 | 10
(1 row)
test=*# commit;
COMMIT
test=# copy test to stdout;
1 06-OCT-23 14:18:28.742152
test=*# copy test to stdout;
1 06-OCT-23 14:18:28.742152
test=*# copy (select * from test) to stdout;
1 06-OCT-23 14:18:28.742152 10
test=*#
Andreas
--
Andreas Kretschmer -
always: read the source ;-)
Not sure how convincing that reasoning is, but it was at least
thought about. I do agree with it as far as the default column
list goes, but maybe we could allow explicit selection of these
columns in COPY TO.
sounds okay
Andreas
--
Andreas Kretschmer - curre
400 tables.
The client is now concerned about the issue that the number of
rows in some of the above tables has increased. Is this possible?
In principle, there is nothing wrong with doing this in a maintenance
window, for example.
Regards, Andreas
--
Andreas Kretschmer - currently still
Am 25.10.23 um 11:57 schrieb Matthias Apitz:
El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andreas Kretschmer
escribió:
Am 25.10.23 um 11:24 schrieb Matthias Apitz:
We have a client who run REINDEX in certain tables of the database of
our application (on Linux with PostgreSQL
Am 25.10.23 um 14:11 schrieb Laurenz Albe:
On Wed, 2023-10-25 at 11:59 +0200, Andreas Kretschmer wrote:
Am 25.10.23 um 11:57 schrieb Matthias Apitz:
El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andreas Kretschmer
escribió:
Am 25.10.23 um 11:24 schrieb Matthias Apitz:
We have
On 6 November 2023 12:11:31 CET, Gabriel Dodan wrote:
>Not sure exactly what happened but Postgresql flooded all the available SSD
>space and obviously crashed. It has written a lot of data in the pg_wal
>folder. Most likely it was caused by replication. The postgresql instance
>that crashed wa
://blog.hagander.net/locating-the-recovery-point-just-before-a-dropped-table-230/
Andreas
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com
use it? Disable it or add
an entry for it.
Regards, Andreas
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com
>
>
> Regards.
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com
.
Andreas
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com
/21-2/installing/system-recommendations-and-requirements/linux-servers/disable-ipv6-networking-on-linux-servers.html
Andreas
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com
you find other related messages? by the way, the picture
is hard to read, please post text instead of pictures.
Regards, Andreas
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com
Am 24.11.23 um 13:52 schrieb Les:
Andreas Kretschmer wrote (2023. nov. 24., P,
13:22):
Am 24.11.23 um 12:39 schrieb Les:
>
> Hello,
>
please check the database log, a VACUUM can also lead to massive wal
generation. Can you find other related message
d one took 31.241
milliseconds. Note the query has hints in it
what database are you using? PostgreSQL doesn't hav hints...
Regards, Andreas
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com
=0.15..63.93 rows=200 width=4)
Output: c1
-> Index Only Scan using idx1 on public.t1 (cost=0.15..61.10
rows=1130 width=4)
Output: c1
(4 rows)
now we scan only the index and not the heap.
Regards, Andreas
--
Andreas Kretschmer
CYBERTEC PostgreSQL Services and Support
postgres=# select * from dogs;
dog
--
dog1
dog2
dog3
(3 rows)
postgres=#
Regards, Andreas
--
Andreas Kretschmer
CYBERTEC PostgreSQL Services and Support
Am 28.02.24 um 13:34 schrieb Jason Long:
Hello,
What is the use of a database in read-only mode?
a standby-database will also be in read-only mode.
Regards, Andreas
--
Andreas Kretschmer
CYBERTEC PostgreSQL Services and Support
ailable any more when creating
the primary key? Not even in some kind of intermediary catalogue?
the null-able constraint addition to a column is pointless because by
default all columns are nullable. definition as a primary key adds the
not null constraint.
Andreas
--
Andreas Kretschmer
CY
Am 24.03.24 um 16:41 schrieb Thiemo Kellner:
Am 24.03.2024 um 16:36 schrieb Andreas Kretschmer:
the null-able constraint addition to a column is pointless because by
default all columns are nullable. definition as a primary key adds
the not null constraint.
While this is certainly true
id=1 and val='test1'
and ctid != my_ctid.min;
DELETE 3
postgres=# select ctid, * from demo;
ctid | id | val
---++---
(0,1) | 1 | test1
(1 row)
postgres=#
--
Andreas Kretschmer
CYBERTEC PostgreSQL Services and Support
On 25 November 2017 21:13:22 GMT+01:00, nikhil raj
wrote:
>Hi,
>Any one can please help me out
>
>I want to move a database to 'Y drive' because the size of that
>database is
>large about so can I move only that database to because I got an alert
>of
>low space is there any way
>Currently it is o
Am 11.12.2017 um 17:48 schrieb marcelo:
The installation I'm planning will manage several databases, but not
all of them will change every day.
In order to planning/scripting the pg_dump usage, I would need to know
which databases had some change activity at the end of some day.
How can it be
Am 11.12.2017 um 18:26 schrieb Andreas Kretschmer:
it's just a rough idea...
... and not perfect, because you can't capture ddl in this way.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Am 19.12.2017 um 15:07 schrieb Kellner Thiemo:
Hi
We are developing a data warehouse of which the integration layer will start
with over 100 TB of data. There are not many entities though we probably can
partition and foremost we should use inheritance for the lab results. I just
was wonder
Am 19.12.2017 um 15:58 schrieb Vincenzo Romano:
But accordingly to a discussion with Bruce Momjan, table partitionin
V10 is little more than syntactic sugar around old-fashioned table
partitioning.
there is always room for improvements, but table-partitioning in pg10 is
much, much better th
Am 20.12.2017 um 16:08 schrieb mark:
postgresql process used over 70% of memory and occuered OOM.
what should I do to deal with this problem?
https://www.postgresql.org/docs/current/static/kernel-resources.html
18.4.4. Linux Memory Overcommit
Regards, Andreas
--
2ndQuadrant - The PostgreSQL
Am 20.12.2017 um 17:24 schrieb Tomas Vondra:
That means if you have all 50 connections active, they may easily
consume 100% of memory, because 50 * 2 is 100. It's even easier if the
connections are executing complex queries, because each query may use
multiple work_mem buffers. So 2% seems a bi
Am 21.12.2017 um 07:31 schrieb Ramar Duraisamy:
Hi friends,
This is Ramar and i have accidentally deleted database in postgresql
through pg admin.
My backup restore not working.
Can you explain that in more detail? How did you take the backup, how
did you tried the restore, which error-mes
101 - 200 of 215 matches
Mail list logo
