On Sun, 2020-05-03 at 16:55 +0530, brajmohan saxena wrote:
> Is there cluster index in PG ? Do we have Indexed Organized Table concepts of
> Oracle in PG ?
No.
You can use CLUSTER to rewrite a table in index order, but the order won't be
maintained.
Yours,
Laurenz Albe
--
Cybertec | https://w
Hi all,
I have something that looks a bit insane:
# ps axl | grep 6145
UID PID PPID CPU PRI NI VSZRSS MWCHAN STAT TT TIME
COMMAND
770 6145 1 0 20 0 241756868 select SsJ - 0:24.62
/usr/local/bin/postgres -D
770 6147 6145 0 23 0 243804 10
Would there be anyone that might be able to help troubleshoot this
issue -- or at least give me something that would be helpful to look
for?
https://www.postgresql.org/message-id/flat/CAGH8ccdWLLGC7qag5pDUFbh96LbyzN_toORh2eY32-2P1%3Dtifg%40mail.gmail.com
https://www.postgresql.org/message-id/flat/
On Mon, May 4, 2020 at 5:43 PM Peter wrote:
>
> Hi all,
> I have something that looks a bit insane:
>
> # ps axl | grep 6145
> UID PID PPID CPU PRI NI VSZRSS MWCHAN STAT TT TIME
> COMMAND
> 770 6145 1 0 20 0 241756868 select SsJ - 0:24.62
> /usr/
On 5/4/20 4:56 AM, Peter wrote:
Hi all,
I have something that looks a bit insane:
# ps axl | grep 6145
UID PID PPID CPU PRI NI VSZRSS MWCHAN STAT TT TIME
COMMAND
770 6145 1 0 20 0 241756868 select SsJ - 0:24.62
/usr/local/bin/postgres -D
Hi all,
This is a shot in the dark in hopes to find a magic bullet to fix an issue I
have, I can’t personally think of any solution myself.
I have a database with hundreds of terabytes of data, where every table has an
integer column referencing a small table. For reasons out of my control and
On 5/4/20 2:32 PM, Fehrle, Brian wrote:
Hi all,
This is a shot in the dark in hopes to find a magic bullet to fix an
issue I have, I can’t personally think of any solution myself.
I have a database with hundreds of terabytes of data, where every table
has an integer column referencing a smal
On 5/4/20 3:32 PM, Fehrle, Brian wrote:
Hi all,
This is a shot in the dark in hopes to find a magic bullet to fix an
issue I have, I can’t personally think of any solution myself.
I have a database with hundreds of terabytes of data, where every
table has an integer column referencing a s
On Mon, May 04, 2020 at 12:55:38PM -0700, Adrian Klaver wrote:
! > The 90206 is continuously growing. It is the unspecific, all-purpose
! > worker for the www.bareos.com backup tool, so it is a bit difficult to
! > figure what precisely it does - but it tends to be rather simple
! > straight-forwa
On Tue, May 5, 2020 at 10:13 AM Peter wrote:
> BTW, I would greatly appreciate if we would reconsider the need for
> the server to read the postmaster.pid file every few seconds (probably
> needed for something, I don't know).
> That makes it necessary to set atime=off to get a spindown, and I
> u
Hello,
We have run into a strange situation with our database. A temporary table
was created some time ago and that session has since died. However, the
temporary table stuck around. It's been around long enough that postgres
stopped accepting writes to prevent transaction ID wraparound. Problem i
When I try to install PostGIS version 2.5 to a Postgresql-11 installation
on Fedora 32 I get warning that nothing provides for these packages:
- nothing provides libproj.so.19()(64bit) needed by
postgis25_11-2.5.4-1.f32.x86_64
- nothing provides libSFCGAL.so.1()(64bit) needed by
postgis25_11-2.5
On 5/4/20 3:32 PM, Fehrle, Brian wrote:
Hi all,
This is a shot in the dark in hopes to find a magic bullet to fix an
issue I have, I can’t personally think of any solution myself.
I have a database with hundreds of terabytes of data, where every
table has an integer column referencing a s
Ricky Ramirez writes:
> We have run into a strange situation with our database. A temporary table
> was created some time ago and that session has since died. However, the
> temporary table stuck around. It's been around long enough that postgres
> stopped accepting writes to prevent transaction I
Forgive me for forgetting the basics PG 11.2 on Ubuntu Bionic, amd64. No
extensions enabled.
On Mon, May 4, 2020 at 4:54 PM Tom Lane wrote:
> Ricky Ramirez writes:
> > We have run into a strange situation with our database. A temporary table
> > was created some time ago and that session has si
I guess it is long route, once I was setting up POSTGIS on one of our cluster.
I had to install all of these components by downloading them from their sources.
Regards,
Virendra
On Monday, May 4, 2020, 4:40:53 PM PDT, Clifford Snow
wrote:
When I try to install PostGIS version 2.5 to a
Hi,
I'm running standard pgbench and what's kinda strange copy pgbench_accounts
from stdin is blocking my other query which is \dt+.
Does copy hold any exclusive lock or there is something wrong with my
system?
i'm using pgbench=> SELECT version();
-[ RECORD 1 ]
Ricky Ramirez writes:
> Hello,
>
> We have run into a strange situation with our database. A temporary
> table was created some time ago and that session has since died.
> However, the temporary table stuck around. It's been around long
> enough that postgres stopped accepting writes to prevent
>
On Tue, 5 May 2020 at 13:05, pinker wrote:
> I'm running standard pgbench and what's kinda strange copy pgbench_accounts
> from stdin is blocking my other query which is \dt+.
> Does copy hold any exclusive lock or there is something wrong with my
> system?
COPY does not. However, pgbench does TR
thank you David.
So it would need to run inside single transaction to cause lock, right? do
you know if pgbench is opening transaction?
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
On Tue, 5 May 2020 at 14:50, pinker wrote:
> So it would need to run inside single transaction to cause lock, right? do
> you know if pgbench is opening transaction?
The TRUNCATE and COPY are done in the same transaction. You can see
the code in
https://github.com/postgres/postgres/blob/REL_11_
21 matches
Mail list logo
