Skip to main content
RBB's user avatar
RBB's user avatar
RBB's user avatar
RBB
  • Member for 9 years, 10 months
  • Last seen more than a month ago
  • Johannesburg, South Africa
12 votes
1 answer
20k views

Can I do VACUUM FULL to pg_largeobject table?

7 votes
1 answer
8k views

postgres backup for specific table with blob oid

5 votes
3 answers
17k views

copy command in postgresql to append data

4 votes
2 answers
8k views

How to dump multiple databases of the same cluster in single execution?

3 votes
1 answer
1k views

How to capture client host name in postgresql?

3 votes
0 answers
2k views

Downgrade working postgres cluster 10 to 9.x

3 votes
1 answer
4k views

oid vs bytea in postgres

3 votes
1 answer
1k views

Error while restoring Postgres DB Dump

3 votes
2 answers
2k views

How to convert numeric values to text in sql for select query

2 votes
2 answers
190 views

Select query not giving result for inner query values

2 votes
1 answer
4k views

Change postgresql data directory location

2 votes
2 answers
2k views

trim is not working for few string

2 votes
1 answer
2k views

How currval of sequence being preserved during the backup and restore in postgres

2 votes
0 answers
901 views

RAISE NOTICE doesn't work as expected while using within Dynamic SQL block

2 votes
1 answer
2k views

XID wraparound metrics are unclear

1 vote
1 answer
4k views

Why and When the pg_stat_activity's most of the columns are null?

1 vote
1 answer
2k views

Is it possible that information_schema.columns doesn't hold an user table column information?

1 vote
1 answer
2k views

enabling fsync in postgresql 9.1

1 vote
1 answer
1k views

SELECT query slowing down the wal replay in replication server

1 vote
0 answers
956 views

Is there any way to reduce pg_largeobject size?

1 vote
0 answers
354 views

will vacuumlo find orphaned objects

1 vote
0 answers
614 views

autovacuum daemon considers pg_largeobject table?

1 vote
1 answer
875 views

How to get first value from list of value

0 votes
1 answer
69 views

Will PostgreSQL server work if I install the service in mounted partition

0 votes
1 answer
941 views

Postgres-9.1 having more Idle connections

0 votes
2 answers
3k views

select query not returning expected result

0 votes
1 answer
408 views

insert is not working as expected while doing partitioning

0 votes
1 answer
617 views

ilike search really uses its index?

0 votes
0 answers
1k views

WITH clause in Maria DB

0 votes
0 answers
825 views

Do UPDATE statement performance affect indexed column(s) in Postgres?